Scroll left and right!?
You can scroll sideways using the mouse wheel. Just hold down Ctrl + Shift and start scrolling. Down goes right, and up goes left. Remember you can also use Ctrl and the arrow keys, and end and home to jump around your spreadsheet much quicker than scrolling too. Ctrl and arrow keys are one of […]
Find out all about Find.
Most people know about Find. You can use it in most computer applications, word, excel, web browsers. When you use Find in Excel, there are a few features to be aware of to help you get the most out of your search. First – what are you trying to find? You can enter a word, […]
Focus Cell
You can now turn on Focus Cell in Excel. This highlights the row and column of the cell you have activated. Handy if you want to be able to see easily all the data in the row or column that you have selected. To turn on Focus cell, use the button on the View menu. […]
Navigation Pane
You can now turn on a Navigation Pane. Find it under View Menu. Shortcut keys: Alt W, K. This brings up a list of all the sheets in your workbook. Each sheet has an expand arrow, and if you click that it brings up a list of tables, charts, pictures, and sections of that sheet. […]
New Window on the world, or at least on your spreadsheet.
When you want to see two parts of your spreadsheet at once, New Window is what you want to be using. Found in the View menu, in the Window Section. (Shortcut keys Alt, W, N) Activating New Window will open another window to the current workbook almost as if it was another workbook. So now […]
Side by side (With thanks to Harry M. Woods)
You can view two workbooks side by side and scroll them together. Very handy if you are comparing them. View Menu, Window Section, View Side by Side. (Shortcut Alt, W, B) If you have more than one other workbook open, you will then get to choose which workbook you would like to put with the […]
Split: See your spreadsheet differently.
When you want to view two different parts of your spreadsheet at once, you can use Split. Split is found in the View Menu, Window Section. (Shortcut Key Alt, W, S) This will cut your spreadsheet into four sections, based on the current active cell, creating sections above, and to the left of the active […]
Easily add names for cells.
I have written about naming cells and why it is a good idea before. Here is an easy way to do a whole lot of those at once. Your data has to be set out in a particular way. I have a small example here. Select all the data, from the Income cell to the […]
What is faster than scrolling? Jumping. Go To…
Home menu, Editing section, Find & Select, Go To… or Shortcut key Ctrl + G, or F5. You can type in a cell reference, click OK and be taken right there. You can use it to jump to another sheet, but have to type in the name of the sheet, then !, then the cell […]
I still haven’t found what I am looking for… solved.
Hiding under the Find & Select drop down is Go To Special… Find & Select, can be found on the Home Menu and is the Editing section. Click on the drop down and choose Go To Special… Shortcut key F5 will open the Go To dialogue box, and from here you can choose Go To […]