Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Is there an icon to use showing visible cells only?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default Is there an icon to use showing visible cells only?

You mean to limit the selection to visible cells only?

In xl2003:
tools|customize|Commands tab|Edit Category|look for Select visible cells
Drag it to your favorite toolbar

Or hit alt-;
(alt-semicolon)

shive_s wrote:

--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 638
Default Is there an icon to use showing visible cells only?

Right click on one of the toolbars and select Customize. Click on the
Commands tab of the dialig box. Select Edit from the Categories
listbox. The Select Visible Cells button is located near the bottom
of the Commands list box. Simply click and drag it to the location on
the toolbar where you want it to be placed.
shive_s wrote:


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
speadsheet wont open but is visible as icon on desktop westwoodview Excel Discussion (Misc queries) 2 June 26th 07 12:51 PM
PDF icon in calculated cells Texas Bald Eagle Excel Discussion (Misc queries) 1 October 1st 05 10:34 PM
Autofilter - display column showing visible row count rgarber50 Excel Discussion (Misc queries) 5 July 26th 05 02:17 PM
Stop excel icon showing at the bottom when opening spreadsheets Rajesh Excel Discussion (Misc queries) 1 June 15th 05 08:25 AM
Stop excel icon showing at the bottom when opening spreadsheets Rajesh Excel Discussion (Misc queries) 0 June 15th 05 08:24 AM


All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"