Entries Tagged 'edit worksheets' ↓
December 27th, 2009 — edit worksheets
Many students over time have asked me the reason for the location of the Microsoft Office Excel 2003 commands that Insert or Delete a row or column of cells. Using the Insert menu to add a row or column makes sense. A new user sees the Insert menu, clicks it and find the options to insert a cell, row or a column as the top three commands of the Insert menu. Makes good sense. But if you want to delete a cell, row, or column, you would think that there would be a Delete menu, right? Wrong. The command to delete a row, or a column is in the Edit menu. And you don’t delete a cell by itself. Go figure!
To maintain a resemblance of consistency in using these commands, I show students how to use the context menu, commonly referred to as the right-click or shortcut menu. They select a range of cells, right-click inside the block of cells, and choose the Insert and Delete commands. I also note to the students that these commands, along with other commands that have the ellipse, the three dots ( … ) that follow a command, indicating a command contains another menu with more options to choose. In this case, the options contain the Insert and Delete commands and the options to insert or delete a row or column.
If you get frustrated trying to find the commands to add or remove a row or column, see how easy it is just to select a block of cells, right-click the cells and add or removed them from a worksheet.
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
October 27th, 2009 — edit worksheets
Moving Excel Worksheets
Opening an Excel workbook displays Sheet1 as the first sheet ready for data. You put another page of information on Sheet2, and add more information to Sheet3. You realize after several sessions that you do more work in Sheet2 than Sheet1. You would like the workbook to open and display Sheet2 ahead of Sheet1 and Sheet3. What do you do. Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
September 30th, 2009 — edit worksheets
Copy and Paste in Microsoft Excel
Click the links below to see how-to video of copying cells: Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
September 29th, 2009 — edit worksheets
Cut and Paste in Microsoft Excel
Click the links below to see how-to video of moving cells: Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
August 4th, 2009 — edit worksheets
Using the Large and Small Statistical Functions
It’s pretty straight-forward using the =Max() function to get the highest value in a range of cells or the =Min() function for the lowest value in a range of cells. But what if you need to get the 3rd largest or the 2nd lowest values in a range of cells? Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
August 3rd, 2009 — edit worksheets
Generate numbers with the =randbetween function
Need to generate some test data to fill-in some rows and columns and not enough time to think up some random numbers? Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
April 21st, 2009 — edit worksheets
New users have asked me, what is the difference using formulas to calculate a total, or using the AutoSum function. Convenience! Continue reading →
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.