Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: make excel automatically insert a new row when you hit enter?


24 Jun 2010   #1

7600x64 ultimate, not SP1
 
 
make excel automatically insert a new row when you hit enter?

I'm working with a basic spreadsheet template I got online for expenses, but I dont know how to make it automatically insert another row when I hit enter so I never run out of rows


My System SpecsSystem Spec
.

24 Jun 2010   #2

Windows 7 Enterprise x64
 
 

There is some very useful info here:

Insert Rows using a Macro

It looks pretty complicated though
My System SpecsSystem Spec
24 Jun 2010   #3

Win7 Home Premium 64x
 
 

I have not found a way to do this,

but I usually right-click on the row where I want to add rows and hit the "i" key, this way I can right-click and then "i" without moving the mouse i do this 5-10 times real quick

instead of rightclicking moving mouse to insert then moving mouse back to row then repeating.

Not a true fix, but it makes it easier.
My System SpecsSystem Spec
.


24 Jun 2010   #4

7600x64 ultimate, not SP1
 
 

Thank you, It looks like there's not really an easy solution... I appreciate the help though, I just group add around 20 at a time, which works for what I need just not as pretty as it would be.
My System SpecsSystem Spec
Reply

 make excel automatically insert a new row when you hit enter?




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:20 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33