Numbers Entered as Fractions

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 →

Related Articles:

    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.

    Zeroes Entered after Decimals

    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 →

    Related Articles:

    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.

    Group Tabs Together

    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.

    Related Articles:

    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.

    Insert and Delete Rows and Columns

    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.

    Related Articles:

    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.

    Printing Big Spreadsheets with Row and Column Headings

    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 →

    Related Articles:

    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.

    Move a Worksheet

    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 →

    Related Articles:

    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.

    Open, Save and Close Microsoft Excel

    Opening, Saving, and Closing Your Excel Workbook

    Click the following links to see video of the following: Continue reading →

    Related Articles:

    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.

    Microsoft Excel Copy and Paste

    Copy and Paste in Microsoft Excel

    Click the links below to see how-to video of copying cells: Continue reading →

    Related Articles:

    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.

    Microsoft Excel Cut and Paste

    Cut and Paste in Microsoft Excel

    Click the links below to see how-to video of moving cells: Continue reading →

    Related Articles:

    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.

    Excel Print Settings

    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 →

    Related Articles:

    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.