Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sharing a neat trick
I just stumbled over a neat trick that I thought I should share.
To expand data in a column so that there is a blank cell between each row. Put some data into A1 to A10 Put 1 into B1 Highlight B1 and B2 Grab the fill handle and drag down to B19 That should leave 1 blank 2 blank...etc in col B Put =INDIRECT("A"&B1) in C1 Grab the fill handle and drag down to C19 That should leave your column A data in column C separated by the #REF error. Whilst column C is still selected Tap F5SpecialFormulas Uncheck Numbers, Text and Logicals and leave Errors checked. OK out Then tap delete Do a CopyPaste Values on column C and delete columns A and B Not groundbreaking stuff but I'm sure it will come in very handy in the right situation. Regards Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to trick a Dynamic Name to be Static when SOLVER is ON... | Excel Worksheet Functions | |||
When Sharing | Excel Discussion (Misc queries) | |||
Trick? for using INDIRECT references in Data Source of Chart? | Charts and Charting in Excel | |||
CountBlank for all Names in a Column, and another trick | Excel Discussion (Misc queries) | |||
What is the trick to make rows resize height automatically? | Excel Discussion (Misc queries) |