Sunday, April 17, 2011

How to Return to Normal View in Excel 2007

1. Right-click anywhere on the Excel 2007 screen. A menu will pop up.2. Use the cursor to highlight the 'Close Full Screen' option.3. Click on the 'Close Full Screen' option. Excel 2007 will immediately return to normal vi...
Read more ►

How to Disable Scientific Notation in Excel 2003

1. Highlight the column into which your list will go.2. Right-click anywhere in the highlighted column.3. Choose 'Format Cells...: from the drop-down menu.4. In the 'Number' tab, choose 'Text' from the 'Category' list. Import your da...
Read more ►

How to Create a Pivot Table From Multiple Sheets

1. Open the Excel workbook that has the worksheets you want to use to create a Pivot Table. Click a blank cell that you aren't using in the Pivot Table report.2. Start the Pivot Table and Pivot Chart Wizard by pressing the following keys 'ALT' 'D' 'P.' The Pivot Table and Pivot Chart Wizard box will open.3. Check the box next to 'Multiple consolidation ranges' under the question that asks 'What is the data that you want to analyze?'4. Check the box next to 'Pivot Table' when asked what type of report you want to create; click 'Next.'5. Check the box next to 'I will create the page...
Read more ►

How to Hide the Standard Toolbars in Office

1. Click 'Start' > 'All Programs' > 'Microsoft Office,' and then click on the MS Office program you want to use.2. Right-click on the blue question mark icon in the upper right-hand corner of the program window. The icon is on the same line as the 'Home' and 'Insert' tabs.3. Choose 'Minimize the Ribbon.' The ribbon disappears.4. Show the ribbon again by right-clicking the question mark icon and choosing 'Minimize the Ribbon.' (See the check mark next to 'Minimize the Ribbon' when minimize is activ...
Read more ►

Saturday, April 16, 2011

How to Recover an Excel File from Autosave

1. Open Microsoft Excel to enable the recovery features available in the Office 2010 suite.2. Recover a file you haven't yet saved. Select 'File,' and then 'Recent.' Choose 'Recover Unsaved Workbooks.' From the saved drafts folder that displays, choose your file and click 'Open.' Select the 'Save' icon and name your file to save it properly.3. Recover a previous version of a file to which you forgot to save changes. Open the file upon which you were working. From the File tab, select 'Info.' From the versions listed, select the one labeled '(when I closed without saving).' Click 'Restore'...
Read more ►

How to Move Excel Macros to Another PC

Copying the Workbook1. Determine where your macros are saved. You can save the macros you create in the workbook you are currently using or in your personal workbook. If you want to use your macros across different workbooks, you are most likely saving them to the personal.xls workbook.2. Copy the workbook where the macros are saved to your chosen storage medium.3. Copy the workbook to the new computer and start using your macros.Using the VBA Editor4. Copy the actual macros themselves from the Visual Basic editor.5. Go to Tools–Macro–Visual Basic Editor.6. Go to the Modules folder...
Read more ►

Friday, April 15, 2011

How Can I Get Rid of Page Breaks in Excel?

1. Select the worksheet that you would like to print. Select 'Page Break Preview,' in the View tab.2. Click the page break that you would like to delete. Click breaks within the page setup menu. 'Click 'Remove page break.'3. Click 'Select All' at the top left-hand corner of the worksheet. Scroll to the Insert menu Select 'Reset All Page Breaks.'4. Remove page breaks in the Excel for Mac version by rolling the mouse over the page break -- which is a dotted line. Click on it then go to the Insert Drop-down menu.5. Scroll down to and select 'Remove Page Break.' This removes the page break...
Read more ►

How to Change Text Case in Microsoft Excel

How to Change Text Case in Excel 20071. Open the Excel spreadsheet.2. Click on the cell that is next to the first data cell in the row of cells to be changed.3. Type in =Lower (cell#) to change the text to lower case. Type in =Upper(cell#) to change the text to upper case. Type in =Proper(cell#) to change the text to proper case.Example: In cell B6 type in: =Proper(A6) to change the text in the A column to proper case.4. Click 'Home' and then 'Fill>Down,' or click and drag down the row of adjacent cells to fill them with the text-case formula. The row should now contain the new text...
Read more ►

How to Include a Signature When Sending Excel Email As an Attachment Button

Create the Signature Line1. Open the Excel worksheet.2. Click on the worksheet where you wish to insert a signature line.3. Click the 'Insert' tab on the command ribbon.4. Click the down-arrow on the 'Signature Line' button in the 'Text' group. A drop-down list appears.5. Click 'Microsoft Office Signature Line.' A 'Signature Setup' dialog box opens.6. Type the information to appear under the signature line: suggested signer, suggested signer's title, suggested signer's email address and instructions.7. Select the check box for 'Allow the signer to add comments in the Sign dialog.'8....
Read more ►

How to Reduce the Size of an Excel Spreadsheet

1. Make a backup copy of the file you want to reduce.2. Open the Excel document and hit 'Ctrl' ' End' in each tab of the spreadsheet. You're looking for the last cell with data in it, in effect the lowest, right-most cell in the worksheet. For many sheets, this cell will be well outside of what you might have thought the spreadsheet contained.3. Select unused columns by clicking on a column header, then holding down the 'Ctrl' 'Shift' 'Right Arrow' keys. This will select all columns to the right of the one you selected, including the one you selected. Press the 'Delete' key.4....
Read more ►

How to Ungroup Worksheets in Excel

1. Start Microsoft Excel 2007 and open a workbook from your files that contains worksheets that are grouped together.2. Locate the worksheet tabs at the bottom left of the opened workbook. The sheet tabs that are white are the ones that are grouped together.3. Hold down the CTRL key on your keyboard and click on the sheet tab of the worksheet that you want to ungroup from the rest of the worksheet group. Once you do this, the worksheet will be turn back to its set color and become separated from the existing group.4. Release the CTRL key on your keyboard after you have ungrouped the worksheet.5....
Read more ►

How to Unprotect a Microsoft Excel Document

Microsoft Excel 20101. Click the 'File' tab and click 'Open.' Navigate to the file you want to unprotect, select the file and click 'Open.'2. Select the “Review” tab on the ribbon at the top of the screen, and click “Unprotect Sheet” from the Review menu.3. Enter the file’s password if prompted to do so.Microsoft Excel 20034. Click “File” on the toolbar and then select “Open.” Navigate to folder that contains the protected spreadsheet. Select the file and click “Open.”5. Select the “Tools” drop-down menu, select “Protection” and choose “Unprotect Worksheet.'6. Enter the file’s password...
Read more ►

Thursday, April 14, 2011

How Do I View Two Excel Spreadsheets on Two Screens?

1. Open the first document you wish to view through Excel. This will open your document on one screen.2. Click on the Start Menu at the bottom left of your computer screen, then open Microsoft Excel again. This will open Excel in a separate window.3. Click 'File' then 'Open' from the toolbar at the top of the Excel window, then find and open the second file you wish to view. You now have two files open, in two separate Excel windows. This makes it easy to click back and forth between files, plus copy and delete information as need...
Read more ►

How to Make a Flowchart in Microsoft Office

1. Open Microsoft Word from the 'Microsoft Office' folder under 'All Programs' in the Start menu. Select a new document in Microsoft Word.2. Click on 'Shapes' under the Insert tab to see a list of available shapes. The flowchart category has several shapes useful for creating flowcharts.3. Select a shape you like, and then click on the document to add the shape in that position. You can move the shape by clicking on it and then dragging across the document while holding down the mouse button. Edit your shape using the options available in the menu at the top, and add a text box if you want...
Read more ►

How to Make an Inventory Spreadsheet

1. Open your software. If you need automatic updates with SharePoint, use Excel 2010. If you are creating a simple list for insurance purposes, use a word processing program with tables or a spreadsheet program.2. Determine the data labels to include in your inventory spreadsheet. If you are doing a home inventory, for example, include 'Value' as a column heading, in addition to labels such as 'Item' and 'Serial Number.' For a retail inventory, create headings such as 'Wholesale Cost' and 'Retail Price.'3. Enter your column headings across the first row of your table. Set the first column...
Read more ►

Blogger news