Shortcut for hide/show detail in grouped columns/rows

G

Guest

Is there a shortcut for this other than using the mouse to click the
plus/minus sign or the numbers in the top left of the screen?

Also, is there a shortcut for renaming a worksheet instead of double
clicking or right clicking on it? Similar to F2 for renaming a file name.

Thanks!!
 
D

Dave Peterson

I don't know a shortcut for the first, but you could go through the menu system
via the accelerator keys to rename a worksheet:

alt-o,h,r
(o for fOrmat, h for sHeet, r for Rename)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting grouped rows 3
Expand and Shrink Rows and columns to hide information. 1
Collapse grouped rows and columns on opening workbook 4
Clicking on numbered boxes, plus and minus sign to show and hide d 1
shortcut for external link on trace 2
Hiding/Concealing columns 2
Protected worksheet, showing and hiding Grouped detail 4
Simple macro to hide and show detail - Grouped Rows 1

Top