Click on the worksheet name that will come after the new one you're going to add. To add a worksheet, go to the Sheet Tabs. When you do this, Sheet1 will be highlighted (selected). The easiest way to rename a sheet is to move the arrow over the sheet you want to rename, then right click on it with your mouse. However, as you use Excel to create your own spreadsheets, you'll want to assign different names so you know which spreadsheets contain what information. The default names that MS Excel 2003 assigns worksheets are Sheet1, Sheet2, Sheet3, etc. Individual worksheets within the workbook may be opened by clicking on the Sheet Tabs at the bottom of the spreadsheet screen.
When you open a new or existing MS Excel 2003 file from your computer, you are opening a workbook. The default MS Excel 2003 setting gives you three worksheets in a workbook.
All of the worksheets included in your MS Excel 2003 file comprise a workbook. There are three default worksheets when you open a new MS Excel 2003 file. This technique seems easy for most users to remember.The Definition of Worksheets and Workbooks There are a couple of tricks for unhiding, but I’ve found most users forget them because they don’t use them often enough to commit them to memory. Then, choose Row or Column from the Format menu, and select Unhide. In Excel 2003, use the Name Box to select cell A1. Then, select Unhide and Excel will expose the hidden row or column. Next, click the Format dropdown in the Cells group (on the Home tab) and choose Hide & Unhide. Excel will select cell A1, but you won’t see that happen, because the cell’s hidden. When row 1 or column A is hidden, enter A1 in the Name Box, and press Enter. It’s a simple task, but a problem arises when you want to unhide row 1 or column A because there’s no row or column above or to the left, respectively. Use the same process to unhide multiple non-contiguous rows and columns as you would a single row or column, just select a larger range. In the sheet below, I selected columns C and E to unhide column D. Select the adjacent columns or rows, right-click, and select Unhide from the resulting context menu. You can quickly discern that a row or column is hidden by the missing header. Unhiding is also simple. In Excel 2003, choose Column or Row from the Format menu, and then select Hide. To hide a row or column, you click the header to select the entire row or column, right-click the selection, and choose Hide from the resulting context menu. To hide multiple noncontiguous rows or columns, select the rows or columns and choose Hide & Unhide from the Format dropdown in the Cells group.
#UNHIDE FIRST COLUMN IN EXCEL 2003 HOW TO#
Today, I’ll show you how to unhide row 1 and column A.įirst, let’s run through the instructions for hiding and unhiding rows and columns, just in case this task is new to you. When unhiding a row or column, you select the adjacent rows or columns, but there’s no row above row 1 or column to the left of column A, which presents a bit of a conundrum. Hiding and unhiding rows and columns is a straightforward and easy task, unless you’re trying to unhide row 1 or column A.
Learn an easy to remember method for unhiding row 1 and column A. The typical unhiding techniques don't work everywhere in Excel. How to unhide row 1 and column A in an Excel sheet