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

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

Thread Tools

Similar help and support threads
Thread Forum
Make Excel 2010 Automatically Organize by Column "A" with Header
Hi all, I'm working on an excel spreadsheet for my passwords. My columns are labeled website, username and password, respectively. I know how to go to data>sort to sort what I have so far, but is there a way for me to be able to put a new website, username and password at the bottom of the list,...
Microsoft Office
Ms office excel 2010 symbol not working to insert on page
ms office excel 2010 symbol not working to insert on page, , all the symbols when you press " insert " symbol and the character box microsoft excel and word. what might be the issue....
Microsoft Office
Excel: How can I insert the value of cell into ActiveX button caption?
Hi, I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I...
Microsoft Office
word 2010 insert horizontal line & not automatically
Good People, Add me to the list of people who don't like the new ribbon. Before with 2007 I could insert a horizontal line of a certain width AND NOT using the auto option where 3 equals turns into a horizontal line. Now in 2010 the most I can get a minimal width horizontal line. I do not...
Microsoft Office
Computer will not enter standby automatically
Hi, I have a PC that I use as a media center attached to my TV running Windows 7 RC and it worked perfectly until about a week ago when I upgraded my laptop to Windows 7 and placed them both in the same Homegroup. Every since then the Media Center will not enter standby mode either...
General Discussion

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 01:02.
Twitter Facebook Google+