February 24th, 2010 — type or insert cells, rows and columns
The first time a new student enters a fraction in a cell, the number changes into a date. If you know you will be entering a series of fractions in a worksheet that will be used in calculations, change the cell format to recognize those values as fractions instead of text. Here is how to make that change. 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.
February 22nd, 2010 — format worksheets
Entering numbers followed by a decimal with trailing zeros will not immediately display the zeros. The default format for a number is the category called Number that does not display decimal. Here’s how to display zeros in a cell. 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.
February 4th, 2010 — format worksheets
Group Tabs Together To Perform A Task Across The Group
You have three worksheets that will have the same column headings and/or the same row headings/labels. The only thing that will change are the numbers. So make it easy for yourself. Make the column headings and row labels of all three worksheets at the same time.
Open Excel. The three worksheets are displayed and labeled as Sheet1, Sheet2, and Sheet3. The active worksheet is Sheet1. Inactive worksheets are displayed as tan-colored tabs. Hold down the Ctrl key and click on Sheet2 and Sheet3.
In column A, type the numbers 1 through 5 in each cell of that column. In cells B2, C2, D3, E3, and F3, type the first 5 letters of the alphabet (A B C D E). Now, click on Sheet2 and Sheet3. You’ve typed into three different worksheets at the same time, with the same information.
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.
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 31st, 2009 — format worksheets
Gridlines, Row and Column Headings
Over the course of a semester, several students in my Excel class print their first Excel exercise for me to correct and ask how to print the Gridlines, column headings (not headers) for each page, and the row numbers and column letters that are not automatically printed with the spreadsheet. 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.
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.
October 1st, 2009 — close workbooks, open workbooks, save workbooks
Opening, Saving, and Closing Your Excel Workbook
Click the following links to see video of the following: 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.
September 21st, 2009 — print worksheets
After you enter data into your Excel spreadsheet, it’s time to print it out. You click the Print command. It displays a dialog box with a section labeled Print What. You think the answer is obvious! Print the information I just entered, right? Not so fast. 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.