There are two techniques you can use when wanting to name your sheets in Microsoft Excel. You can Double Click on the name of the sheet, type the name and press enter. You can also Right Mouse Click on the name of sheet and select from the list, Rename. When working in Microsoft Excel you have a Workbook Name which means the name of the file. In just one sheet you have 16,000 columns and over 1 million rows. English pages and pages worth of data in just 1 sheet. To navigate efficiently though all these sheets, you might like to Right Mouse Click on the arrows on the left-hand corner. This will display a list of all the names of the sheets in your Microsoft Excel Workbook. No, they do not appear in alphabetical order. They appear in the order that you need to work with them. You can also Right Mouse Click on the Name of the sheet to change is tab colour, this can make it easier to find.
To make a copy of a sheet you can Right Mouse Click and select Move or Copy but it’s much easier if you hold the CTRL key as you drag. You should see a plus sign, this means it’s performing a copy.
YouTube On How To Rename Sheet In Excel
This video will walk you through how to create a new sheet, rename it, copy a sheet and group sheets. The best thing about grouping sheets is that once they are grouped what ever you do in one cell will display in each of the other sheets. Imagine the formula or function was incorrect for each department sheet in cell A50. Group your sheets, make the change ungroup the sheets, that’s it they are all done all 20 different department sheets you had.
How To Show All Formulas In Excel
Some times when we are working in Excel, we want to study the pattern of the formulas. Why does the first function work but not the following. What has changed in the pattern of the function. This is particularly helpful when working with Absolute Cell Referencing. Visit my blog on “How To Keep The Same Cell Reference“. For help on Absolute Cell referencing.
To reveal all formulas created in Excel.
Press Ctrl ~ or go to the Formulas Tab and Select Show Formulas. To display the answers rather than the formulas or functions behind it press the Ctrl ~ key again.
Microsoft Office Small Group Training Sessions
AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.
Call Now M 0414 417 059 visit www.azsolutions.com.au