Format: Protection Section.
In the continuing mis-named Cells section of the home menu is the Format drop down, that contains the Protection Section where you can Protect Sheet… or Lock Cell. Shortcut keys: Alt, H, O then P or L. Locking a cell only has an effect once you Protect the Sheet. By default cells are Locked. The […]
Three things I need you to know: Sheets
In the continuing mis-named Cells section of the home menu are three things you can do with Sheets. Rename, Move or Copy Sheet.. and Tab Colour. Short Cut keys; Alt, H, O then R, M or T. Each of these can also be done by Right Clicking on the sheet name. You can move or […]
Change the way you see the cell: Format Section.
The Cells section of the Home Menu, holds the Format menu, where you can get the Cell Size just the way you want it. You can adjust the way the cells in the sheet look by using the Cell Size Section. Row Height allows you to type in a number for the row height. Of […]
Back to basics continued, more formatting options for cells.
You can format a cell in multiple ways 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 […]
Back to basics: Formatting
Covering some of the essential knowledge when first starting to use a spreadsheet, here we will cover some Formatting of cells. On the Home menu, is a section called Number. Which is slightly misleading, because it is about a lot more than numbers. This is where you can set how the user sees the information […]
Automate Your Excel Tasks…
(This post is about Macros and VBA. See here for a discussion on other automation options in Excel.) 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 […]
Automation in Excel: the choices.
Traditionally, the way to automate tasks in Excel, was to use VBA. See this post for how to turn on the developer tab and access this amazing tool. The new kid on the block in terms of automation in Excel is Office Scripts. Both allow you to record your actions, so no real programming knowledge […]
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 […]