ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Toolbar commands (https://www.excelbanter.com/excel-discussion-misc-queries/25027-toolbar-commands.html)

cvgairport

Toolbar commands
 
Is there a way to get the "Row Hide" function from the Format/Row/Hide menu
onto the icon lbar? I know it doesn't have a separate icon but I have been
able to put words on the icon bar before like File Close.

Thanks!

Amy

Duke Carey

Would you settle for a keyboard shortcut?

Ctrl-9 will hide the selected row(s), and Ctrl-Shift-9 will unhide

Ctrl-0 will hide the selected column(s), and Ctrl-Shift-0 will unhide



"cvgairport" wrote:

Is there a way to get the "Row Hide" function from the Format/Row/Hide menu
onto the icon lbar? I know it doesn't have a separate icon but I have been
able to put words on the icon bar before like File Close.

Thanks!

Amy


cvgairport

That works. Thanks!

"Duke Carey" wrote:

Would you settle for a keyboard shortcut?

Ctrl-9 will hide the selected row(s), and Ctrl-Shift-9 will unhide

Ctrl-0 will hide the selected column(s), and Ctrl-Shift-0 will unhide



"cvgairport" wrote:

Is there a way to get the "Row Hide" function from the Format/Row/Hide menu
onto the icon lbar? I know it doesn't have a separate icon but I have been
able to put words on the icon bar before like File Close.

Thanks!

Amy


Gord Dibben

ToolsCustomize

Click on "Format" then "Row".

Drag the "Hide" to an open Toolbar.


Gord Dibben Excel MVP


On Thu, 5 May 2005 12:51:04 -0700, "cvgairport"
wrote:

Is there a way to get the "Row Hide" function from the Format/Row/Hide menu
onto the icon lbar? I know it doesn't have a separate icon but I have been
able to put words on the icon bar before like File Close.

Thanks!

Amy




All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com