Insert blank row automatically

fabs286

New Member
Joined
Aug 15, 2013
Messages
4
Hello everyone!

Before hand, thank you for taking the time to reply!

I have an expenses sheet where I would like to add something I saw on a template...

press "tab" in the last populated cell of a table to insert a blank row. (below or above, it doesn't matter)
So I can add the next expense.

Any method along those lines would be helpful otherwise.

Thank you again!
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,347
Office Version
365
Platform
Windows
If your data is in an actual Excel table it should automatically insert a new row below your data.

1- Click on any cell in your data range
2- Press CTRL-T
3- That should turn your data range into a table.
 

Forum statistics

Threads
1,082,631
Messages
5,366,665
Members
400,910
Latest member
TywithXl

Some videos you may like

This Week's Hot Topics

Top