Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving Row Data
Hi,
It just ocurred to me. Example:- In a worksheet, the top 2000 rows by 50 columns are used to hold data that is being manipulated. The cells in this range are all carefully formatted. All rows below this range are hidden and have not been formatted, as I, maybe wrongly, think that this can increase the Used Range and result in undue overheads. Query:- If cell contents are deleted using Shift(XlUp), does this mean that the 2000 rows will lose their formatting from the bottom up ? If yes, what is the best solution. In the same vein, but more academic, if entire columns are formatted, will the formatting be gradually eroded from the bottom up if cells are shifted up or rows deleted ? regards, Don -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Moving data from one worksheet to another whilst removing the data | Excel Discussion (Misc queries) | |||
moving data to non autofarmatted book changes data- Why? | Excel Discussion (Misc queries) | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) |