Resources on Basic Excel @ ExcelOptimize.Com - Part 2
Currently Browsing: Basic Excel
Posted by Andrian in Basic Excel on 02 18th, 2009 | No Comments

Have Excel Always Open Certain Workbook(s)

Problem: You always use Excel to work on a particular workbook. Every time that you open Excel, you want this workbook to open automatically. Strategy: Place the fi le (or a shortcut to the file) in the XLStart folder. This folder can generally be found in the C:\Documents and Settings\ Username\Application...
Read More
Posted by Andrian in Basic Excel on 02 17th, 2009 | No Comments

Why is there a “:2” after my workbook name in the title bar?

Problem: As shown in Fig. 57, and without any apparent reason, a “:2” appeared after the spreadsheet name in the title bar of your spreadsheet. What is this and what caused it? Strategy: This is an annoying thing. It got turned on when you accidentally chose Window – New Window from the menu....
Read More
Posted by Andrian in Basic Excel on 02 16th, 2009 | No Comments

Arrange Windows To See Two Or More Open Workbooks

Problem: You have two workbooks open. One workbook contains a listing of airport codes and their respective cities, as shown in Fig. 47. In the other workbook, you are building a list of recommended packing items for students going on seven-city tours. Currently, you are shifting back and forth between...
Read More
Posted by Andrian in Basic Excel, Excel Formulas on 02 15th, 2009 | No Comments

Create Easier-To-Understand Formulas With Named Ranges

Problem: As shown in Fig. 206, your worksheet contains several different formulas. It would be easier to understand the results if each component of every formula were named for what it represented and not just for the cell it came from.Strategy: Use named ranges to make formulas easier to understand.1)...
Read More
Posted by Andrian in Basic Excel on 02 15th, 2009 | No Comments

How To Make A Wide Report Fit To One Page Wide By Many Pages Tall

Problem: After creating a wide report, it is printing four pages wide, as shown in Fig. 44. You want to make it fit one page wide. Strategy: Ultimately, you will set the Page Setup to print to one page wide by <blank> pages tall. Before you can do that, you should follow these steps. Eliminate...
Read More
Posted by Andrian in Basic Excel on 02 14th, 2009 | No Comments

How To Print Page Numbers At The Bottom Of Each Page

Problem: You are printing a lengthy report. You want the pages to be numbered. Strategy: The Header and Footer options are controlled on the third tab of the Page Setup dialog box. There are a variety of formats that can be specified on this tab. Select Page Setup from the File menu. The dialog box...
Read More
Posted by Andrian in Basic Excel on 02 13th, 2009 | No Comments

Print A Letter At The Top Of Page 1 And Repeat Headings At The Top Of Each Subsequent Page

Problem: As shown in Fig. 35, you are sending out a worksheet that contains instructions, followed by a lengthy report. You would like the headings to appear at the top of each page after the first page. You don’t want the headings to appear at the top of the letter on page one. Strategy: Printing...
Read More
Posted by Andrian in Basic Excel on 02 12th, 2009 | No Comments

How To Print Titles At The Top Of Each Page

Problem: The report shown in Fig. 30 has 90 rows of data. You want tohave the title rows print at the top of each printed page. Strategy: Printing options are controlled on the fourth tab of the Page Setup dialog box. In this case, you want rows 1 through 5 to print at the top of each page. Select...
Read More
Posted by Andrian in Basic Excel on 02 11th, 2009 | No Comments

How To See Headings And Row Labels As You Scroll Around A Report

Problem: As shown in Fig. 28, you have a wide spreadsheet. There are headings at the top of the spreadsheet and there are several columns of labels at the left side of the spreadsheet. You also have monthly sales figures that extend far to the right. You need to be able to scroll through the sales fi...
Read More
Posted by Andrian in Basic Excel on 01 23rd, 2009 | No Comments

Ribbon and Office Button

When you first launch Excel 2007, the program opens up the first of three new worksheets (named Sheet1) in a new workbook file (named Book1) inside a program window like the one shown in Figure and Color Plate 1. The Excel program window containing this worksheet of the workbook is made up of the following...
Read More
 Page 2 of 3 « 1  2  3 »