News

Learn how to switch between Excel worksheets using keyboard shortcuts, Watch Window, Activate Sheet, Name Box. Go To dialog box, Hyperlinks. VBA Macro.
If Tabs are missing or not showing in your Excel worksheet, it may be due to some changes within your Excel settings. Take these steps to fix the issue.
To add a worksheet, click the "+" next to the worksheet tabs at the bottom of the Excel window, and double-click a tab to rename it.
How to Ungroup Tabs in Excel. Business managers and owners group worksheets in Excel so that changes made to one worksheet apply automatically to all connected worksheets. When you group ...
Q. Some of my Excel spreadsheets contain many worksheets—up to 36 in some cases. But not all the worksheet tabs show at the bottom of the screen. Is there some way to make more tabs visible, such as ...
Open the Excel workbook and select the worksheet to be hidden. Click on the "Home" tab in the menu bar, then click on "Format" in the "Cells" group.
To do so, open a new worksheet in Excel 2011 and enable the Developer tab in the Ribbon: In preferences (Excel -> Preferences), open the Ribbon pane and select Developer at the bottom of the Tab list.
I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...
If you're not using these worksheet-related tricks, you're working harder than you have to! Susan Harkins shares five of her favorites.