Sunday, May 9, 2010

EXCEL - Unhide Multiple Worksheets at Once

Note, you can only do this with a VBA macro (there is no shortcut) but it's easy!

Here's how to Create a macro using Microsoft Visual Basic
  1. On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor.
  2. On the Insert menu, click Module.
  3. Type or copy the code below into the code window of the module.
  4. If you want to run the macro from the module window, press F5.
  5. When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.
The code:

Sub UnhideAllSheets()
    Dim wsSheet As Worksheet

    For Each wsSheet In ActiveWorkbook.Worksheets
        wsSheet.Visible = xlSheetVisible
    Next wsSheet
End Sub

Tuesday, May 4, 2010

Excel | Charts - How to show the grand total on top of stacked bars?

This works great!

Compute the sum in the worksheet. Copy this range, select the chart, and use Paste Special to add it as a new series. This makes a new column stacked atop the others, not what you want. Select this series, go to Chart menu > Chart Type, and choose a line type chart. Double click the line, on the Data Labels tab, choose the Show Value option, and on the Patterns tab, choose None everywhere so the series becomes invisible. Finally, double click on the series of labels, and on the Alignment tab, choose Above for Position.
- Jon
Jon Peltier, Peltier Technical Services, Inc.

Saturday, May 1, 2010

Microsoft Office | Permanently Expand Drop-down Menus

How to permanently expand drop-down menus:

In Word, Outlook, or any other program in the Office suite, from the Tools menu, select Customize, and then click the Options tab.

In Office XP or 2003, under "Personalized Menus and Toolbars", check Always show full menus, and then click Close.

In Office 2000, under "Personalized Menus and Toolbars", uncheck Menus show recently used commands first, and then click Close.

If you make these changes in one program, the changes will affect all the others in the suite: Excel, Word, etc.
Related Posts Plugin for WordPress, Blogger...