LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jaws2act
 
Posts: n/a
Default How do I make the verticle scroll bar full size post row delete?

I need to resize my verticle scroll bar in excell to match my remaining data.
This seems like it should be a simple task. example: I have 100 rows of
data. I use a subtotal function to delete duplicates, which doubles the
amount of rows, and shrinks my scroll bar. After I remove the subtotals, my
scroll bar still takes me down 200 rows while I may only have 50 rows of data
now.

HELP!
 
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
Make graphs in Excel all the same size ready to paste into Word - sub210 Charts and Charting in Excel 4 April 25th 23 11:47 AM
Can I make the scroll bar show the row number? Marcia Duckworth Excel Discussion (Misc queries) 11 June 20th 07 08:33 PM
How do i make my picture size display in inches rather than cms? Grouge New Users to Excel 1 March 2nd 05 08:42 PM
How to edit the size and make it bold of the Option Button text? Cammie Excel Discussion (Misc queries) 1 February 23rd 05 01:57 AM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM


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

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"