Forum Home
Press F1
 
Thread ID: 129156 2013-02-06 06:08:00 Excel - a simple question. Digby (677) Press F1
Post ID Timestamp Content User
1326843 2013-02-06 06:08:00 Just getting to grips with Excel 2010 witt he ribbon.

I find that I often hit insert a cell or delete a cell by mistake.
What I mean to do is insert or delete a row or a column.

I have tried to remove the insert or delete a cell option, but can't seem to .

Why do you need to be able to insert or delete a cell ?

To me it seems to put the whole spread sheet out of alignment.

Is there a need to be able to insert or delete cells ?
Digby (677)
1326844 2013-02-06 09:10:00 Well for excel charting, I used to use insert cells to add test data for days already passed. You might have a preliminary chart of data (e.g. load force) vs days for your branch. But then my manager wanted a summary chart of external data from several different company branches and chart it all as one, then needed to insert cells and corresponding data for those days. Excel would update the graph to quickly compare, kind of for round robin testing. kahawai chaser (3545)
1326845 2013-02-06 09:18:00 What you can do, is on the ribbon, right click the Cell Box/area, or any blank part of the ribbon - Customize the Ribbon - On the right hand side of the window that opens under the Home option list right click cells - Remove.

This will remove the complete Cell box in the ribbon - If you ever want to put it back, down the bottom is the reset.

If you want to insert either a row or column anywhere, you can simply go to where you want to insert, right click/insert.
wainuitech (129)
1326846 2013-02-06 22:11:00 Thanks for that Digby (677)
1326847 2013-02-07 06:24:00 Note the "undo" shortcut "ctrl" + "z" works with any version and any Office product.

Once you learn a keyboard shortcut in one product, it usually works in any other Office product.

The exception is "ctrl" + "f", which is "find" almost everywhere, except Outlook, where it's "forward a message"

homeworktips.about.com
kingdragonfly (309)
1