Doing it in Style…
The Style section on the Home Menu gives easy access to set formatting for cells that can be a good place to start. There are a number of set options you can select from rather than having to customise your own formatting. There are also some common number formatting options. Comma [0] and Currency [0] […]
Back to basics continued, more formatting options.
Carrying on with some basic formatting using the Number section on the Home Menu. You can format a cell to be Time. There are a number of different options to choose from for how the time is displayed. To access the first three for these options use the More Number Formats and then the Time […]
Back to basics
It has been just over a year since I started writing Excel Tips once a week. Going back over what I have written about, I have realised I haven’t covered some of the most basic/fundamental features in Excel. So, that is my inspiration for my next few blogs! On the Home menu, is a section […]
Automate Your Excel Tasks…
You can automate tasks in Excel. This is done via macros which are coded in a language called VBA. You don’t actually need to be able to write code to benefit from macros. Excel enables you to record actions and it writes the code for you. You can then tell it to repeat those actions. […]
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 side by […]
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) Split will cut your spreadsheet into four based on the current active cell. Scroll up and down will move both the left and right […]
Freeze, in the name of being able to see what is what.
When you have a large sheet and you want to be able to see the top rows, even if you have scrolled down, then Freeze Panes is your friend. For example, if you have headings in the top row and want to be able to see them, even when you are at the end of […]
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 […]
Make your spreadsheet look less like a spreadsheet.
If you want your spreadsheet to look less like a spreadsheet, or you want more space for your data when showing it to others, then you can make a big difference with a few clicks. Turning off the gridlines and the headings (the letters across the top, and the numbers down the side) can make […]