Autosuggest, Moving Rows & Keyboard Shortcuts

Hi i am not surehow these things work so i hope someone can clarify

1. How does auto suggestion work when i type a letter "w" in a cell sometimes suggestion comes up and sometimes it doesnt? Any way to force suggestion word or something like this?

2. Is there a way to move entire row content to another row while in the same time leaving cleared row space left behind. I know how to move row to another place but this leaves row content behind and if i use ;cut; it cuts cell blocks for some reason so i assume it cuts formulas as well which is a No obviously

3. How can i make a keyboard or mouse shortcut to automatically fill a row as template

Thanks in advance, nice to have community like this to help us newbs!

Edit: Sorry about the title

Hi exceldumm and welcome to the forum,

Judging by the questions you ask I think what you need is a some sort of tutorial that could explain Excels basics. There many useful links on the web where you could find answers to your questions. A simple Google search should give just about anything you need to know about Microsoft Excel.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.