| 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 | |||||