Penny has attended:
Excel Intermediate course
Excel Advanced course
Removing empty rows from spreadsheet
I have a excel spreadsheet where I've deleted the contents but not the rows. Is there a way that you can reformat so I only get the populated rows instead of going through the whole spreadsheet and deleting the rows.
Thank you.
RE: Removing empty rows from spreadsheet
Hi Penny
Thank you for your question - it sounds like you'd like to remove formatting from empty cells, leaving formatting on the populated cells intact.
To do this click under your populated rows in Column A, on the first empty cell.
On your keyboard hold down the shift + control keys then press the down arrow. This highlights every cell from your starting point to the bottom of your sheet. Next, keeping shift and control held down, press the right arrow. Now the highlight expands to include every column.
On the home tab, in cell styles choose the normal style. This should reset the formatting to "nothing" for the cells highlighted.
Let me know if I misunderstood your requirement.
Kind regards,
Andrew
RE: Removing empty rows from spreadsheet
Hi Andrew
My cells are not formatted. All I have is a spreadsheet with lots of names. I randomly deleted some rows throughtout rather then delete the rows and I'm left with a document with lots of empty rows. I wondered if there was an easier way of bringing all the names together rather than going through deleting all the empty rows. Hope this makes sense.
Kind regards
Penny
RE: Removing empty rows from spreadsheet
Hi Penny
Yes it does - thanks for the update.
If your table has a row of labels at the top try highlighting the labels plus all the rows below, including the empty ones, then sorting them (perhaps by last name).
You will find this brings all the empty rows together in a block which makes them easier to delete.
Let me know if this helps.
Kind regards,
Andrew
RE: Removing empty rows from spreadsheet
Hi Penny
Thanks for the update and the great graphic!
The only other option I can think of is to create the line type arrow then, while it it selected click on the Drawing Tools Format tab and choose Shape Outline. Here you can modify the weight, colour. Use Shape effects to add shadows if you wish.
I hope this gets you closer to the kind of arrow you need. Let me know how you get on.
Kind regards,
Andrew
