Custom Views

Tips, Tricks, and Answers

The following articles are available for the 'Custom Views' topic. Click the article's title (shown in bold) to see the associated article.

Additional Ways of Displaying a Hidden First Column
A few ways to show a hidden first column in a worksheet.

Arranging Workbook Windows
If you find yourself working with a number of different workbooks at the same time, you may want to arrange your desktop so you can see each of the workbooks. Here's an easy way to arrange the workbook windows to reflect your working desires.

Changing the Size of Spreadsheet Panes
Selecting the size of the panes in a spreadsheet to fit your viewing needs.

Displaying a Hidden First Column
Hiding columns is easy, even hiding column A. How, then, do you get that left-most column displayed again? Here are a few techniques you can use.

Getting Rid of Spreadsheet Panes
Easy ways to remove the panes in Excel.

Problems with Custom Views
If you get an error when you try to use one of your custom views, it could be due to the protection you have applied to the worksheets. This tip explains why this may cause a problem and what you can do about it.

Splitting Your Spreadsheet Window Into Panes
Get a custom view of a spreadsheet with Excel's pane function.

Working With Multiple Workbooks
Excel allows multiple workbooks to be open at the same time.