When you right click on the column, the entire column will be highlighted, and a menu box will appear. We're going to use column A in this example. Right click on the column header of the column that you want hidden. Remember, when you hide a column, data in that column can still be used in the worksheet. This is the bar where the column letters are: A, B, C, etc.
#UNHIDE A COLUMN IN EXCEL 2003 HOW TO#
Let's learn how to hide columns by using the Column Header Bar. It may be to simplify the worksheet and make it easier to navigate or to protect certain information.Īs with all Microsoft products, there is more than one way to do a certain task. There are a few reasons you may choose to do this.
You can also hide data by hiding cells, rows, and columns within a worksheet. Format>Sheet>Unhide Hiding Columns and Rows To unhide a worksheet so that you may view it again, follow the same steps as you took to hide the worksheet, except this time select Unhide. The worksheet that is active in your window at that time, or the selected worksheets, will then be hidden. Go to Format on the menu bar, then Sheet>Hide. You'll have to unhide it to be able to view it again. When you hide a worksheet, you or anyone else accessing the file will not be able to see it. Hiding a worksheet allows you to remove it from view of others or simply get it out of your way. To delete a worksheet, go to the Sheet Tabs, select the worksheet that you want to delete, right click, and select Delete. Note: You can also go to the menu bar to insert a worksheet. The new worksheet will have a default MS Excel 2003 name. 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. The Definition of Worksheets and Workbooks