Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Mon, 8 Sep 2008 14:52:17 +0100, "Peter T" <peter_t@discussions
wrote: Having formats in columns would not help you to scroll down, other than as a visual indicator. "End" with the arrow keys looks for first or last data entry in a cell. However you can use Ctrl-End which goes to the bottom-right of the used range (which does include formats). If your file takes longer to open than you'd expect or its file size is larger than you'd expect with the amount of data, reason is might be to be due to formats, perhaps in large otherwise unused areas. Regards, Peter T Can you tell me l, is it possible to delete (Get Rid of) Unwanted rows or columns, or not ? And if you can - how, please? I hit control-end and Cell IU 1981 is selected. I want the 'end' to be CS 1175. So far I've spent about 8 hours Googling for anwers and highlighting cells and Delete - to no avail. This is crazy! Thanks - Kirk |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Basic Balance Sheet Problem | Excel Discussion (Misc queries) | |||
Formatting problem with basic excel sheet | New Users to Excel | |||
Visual Basic - Variable Sheet Names | Excel Discussion (Misc queries) | |||
excel sheet with visual basic doesn't open | Excel Programming | |||
copy range from one sheet to another - basic doubt | Excel Programming |