1. Launch Excel by clicking on the 'Excel' shortcut in your Windows Start Menu.2. Open the worksheet for which you want to disable gridlines by clicking on the 'Excel' icon and selecting the 'Open' command.3. Click on the 'View' tab and de-select the 'Gridlines' check box under the 'Show/Hide' catego...
Browse » Home » All posts
Wednesday, March 16, 2011
Tuesday, March 15, 2011
How to Go to Precedent Worksheets in Excel
Enable the Display Options1. Open the saved Excel worksheet.2. Click the 'File' tab on the command ribbon. A list of commands will appear.3. Click 'Options.' The 'Excel Options' dialog box will open.4. Click the 'Advanced' button on the left pane. The 'Advanced' pane will appear.5. Scroll down the right pane to the 'Display' section.6. Select the named workbook in the 'Display Options for This Workbook' text box.7. Select the radio button for 'All' in the 'For Objects, Show' option.8. Open another workbook if it contains the formula's reference cells. An open workbook makes the...
Monday, March 14, 2011
How to Use VBA to Import Data From Excel Into Access
1. Launch Microsoft Office Excel and type 'data1' in A2, and 'data2' in B2. Press 'Ctrl' and 'S' to open the 'Save As' dialog Window and save the workbook in 'C:\Temp\' as 'dataToImport.xlsx.' Click 'Save' and close Excel.2. Launch Microsoft Office Access, click 'Blank Database' and click the 'Create' button. Click 'Database Tools,' and click 'Visual Basic' to open the VB Editor Window. Click the 'Insert' menu and then click 'Module' to insert a new code module. Click the 'Tools' menu, click 'References,' and check the box next to 'Microsoft Excel Object Library.'3. Start by typing the...
How to Open Excel 2007 Without a Blank Document
1. Click on the 'Microsoft Office' button.2. Click on 'Excel Options.' The Excel Options dialog box will open.3. Click on the 'Advance' tab, then scroll down to 'General.'4. Type the name of your file location in the 'At startup, open all files in:' text box. For example, type 'C://MyDocuments/myfile.xls.'5. Click on the 'OK' button. The next time you open Excel, the selected files will open automatical...
How to Use Calendar Control in VBA Excel
1. Start Microsoft Office Excel, select the 'Developer' tab then click 'Visual Basic.' Click the 'Insert' menu and select 'UserForm.'2. Right-click the 'Toolbox' menu and select 'Additional Controls...'. Check the box next to 'Calendar Control 12.0' then click 'OK.'3. Click the calendar control and add it to 'UserForm1.' Click the 'CommandButton' control and add one to your 'UserForm1.' Double-click the 'CommandButton1' to open Microsoft Visual Basic.4. Copy and paste the code below inside the 'CommandButton1_Click()' subroutine.Dim dataString As StringdataString = Calendar1.ValueActiveCell...
Sunday, March 13, 2011
How to Find Hidden Columns in Excel 2007
1. Inspect the column headers at the top of the Excel 2007 spreadsheet. The headers are gray and are labeled with letters in consecutive alphabetical order. Note which letters are missing from the headers. These missing letters indicate which columns are hidden.2. Reveal single or consecutively hidden columns by clicking on the two columns that would be on either side of the hidden columns. For example, if column 'B' is missing (hidden), you will click on columns 'A' and 'C' to select them. To continue that example, if columns 'B' through 'F' are hidden, you will click on columns 'A' and 'G'...
How to Highlight Changes in Microsoft Excel 2003
1. Access the highlight menu. To access this menu, scroll to the “Tools” tab and select “Track Changes.”2. Open the Highlight Changes Options menu. Under the submenu that opens scroll to “Highlight Changes” and left-click to access the 'Highlight Changes' menu. Make sure to check the box labeled “Track Changes While Editing.”3. Set up the “When” attributes. By checking this box, you can access a dropdown menu where you can choose from the following: All (which will track changes by everybody), Since I Last Saved (which will track changes from your last save), Not Yet Reviewed (which will...
Saturday, March 12, 2011
How to Find the Author of an Excel Document in 2007
1. Open the Excel document in Microsoft Excel 2007.2. Click the top left 'Office' button, select 'Prepare' and click 'Properties.'3. Look at the top left 'Author' field of the 'Document Properties' panel that appears just above your spreadsheet. This field lists the author of the Excel docume...
How to Insert a Cell Drop
Microsoft Excel 20031. Open the Microsoft Excel 2003 application on your computer. Enter the data you want for your drop-down box into a single column of your spreadsheet.2. Click on the cell where you want the drop-down list to begin so that it’s selected. Click on the “Data” option from the top toolbar menu.3. Click on the “Validation” option and then click on the “Settings” tab. Click on the “List” option from the “Allow” box.4. Enter the reference for all of the cells to be used in the drop-down list into the “Source” box. Click on the box next to the “In-cell drop-down” field so that...
Friday, March 11, 2011
How to Create Dynamic Charts in Excel Using Data Filters
1. Organize the source data in your spreadsheet.2. Create the type of chart specific to your data needs using the Chart Wizard tool.3. Insert data filters to the source data by selecting 'Menu' then 'Data.' Next choose 'Filter' and then 'Auto Filter.' In Microsoft Excel 2007, use the home ribbon and then select 'Filter and Sort Button' followed by 'Filter.'4. Apply the data filter to select the type of data you wish to use in the chart. The chart will automatically change depending upon how the data is filter...
How to Add Add
1. Open Excel and click the Office button. You can open, save or print a document and view the default settings for Excel using this menu.2. Click the 'Excel Options' button located at the bottom of the menu that opens.3. Select 'Add-Ins' located in the options list. You can view and manage your add-ins here.4. Click the arrow next to 'Manage' and select 'COM Add-Ins' from the drop-down list that opens and click 'Go.' A box will open that shows the add-ins that are available for you to add or remove from Excel.5. Select an add-in you want to use in Excel and click 'Add.' The add-in...
How to Do Add
1. Open Microsoft Excel, and click on the 'Office' button.2. Click on 'Excel Options' located at the bottom right corner of the Office menu window.3. Select 'Add-Ins' from the vertical navigation bar on the left of the 'Excel Options' window.4. Check the boxes next to the add-in programs you would like to download, and then click 'OK.'5. Follow the installation prompts to install the add-ins, and then click on 'Add-Ins' located in the toolbar at the top of the Office Excel page to load and use your add-in programs; you can also access them through the data, formula and add-in ta...
How to Create High Resolution TIFF Files From Excel Files
1. Create your file in Microsoft Excel. This can be anything from an invoice to a chart to a simple listing of data.2. Select the area of your Excel spreadsheet that you want to convert to a TIFF file. Go to the 'Page Layout' menu then click 'Print Area' and 'Set Print Area' (this option may appear under 'File' menu in some older versions of Excel).3. Print the file to a standard postscript printer (download a free file at Adobe.com). Name the postscript file and type in '.ps' without the quotation marks as the file extension.4. Open the .ps file in Adobe Photoshop. A dialog box will open,...
How to Make an X Axis in Excel 2007
1. Open the spreadsheet with the data for which you wish to create a graph. Place all the X values in one column and the Y values in a second column. Each row should contain the matching values for both axes.2. Click 'Insert' on the Menu bar and go to 'Chart.' Pick your desired picture and input the description of the graph in the box provided.3. Move to Step 2 of the Chart Wizard to arrange the Chart Source Data. Highlight the columns and their respective headings and click 'Enter.' Choose the 'Series: in columns' button.4. Go to Series tab and fill out the X and Y value fields. Check...
How to Use a Letter to Represent a Value in Excel
1. Launch Microsoft Excel.2. In the Excel spreadsheet, type a letter in the column 'A' (for example, in the cell 'A1'). Type the value, which should be represented by the letter, in the same row in the column 'B' namely in the cell 'B1.'3. Repeat Step 2 to add to the spreadsheet other letters you wish to associate with values. Make sure to add one such 'letter-value' entry per row. In the example shown in the figure, the array 'letter-value' spans six rows from the cells 'A1' and 'B1' to 'A6' and 'B6.'4. In the Excel spreadsheet, select a cell in which you want to insert the value using...
Subscribe to:
Posts (Atom)