If you’d prefer a more ornate month and year, try some clipart. Click Insert > Text > WordArt and choose a style for your text, then type June 2015 in the field box. Now, let’s add a fancy title (June 2015). Highlight Row A1 through G1, then select Merge & Center from the Merge button under the Home tab, Alignment group. Click the Borders button in the Fonts group, under the Home tab, then choose All Borders from the drop-down list.Ģ-Page Setup and Borders for your calendar.Įnter the days of the week in Row 2 (A2:G2), center horizontally and vertically, then enter the days of the current month on the calendar. This is the area of your spreadsheet that Excel prints, as long as you don’t change the Print Area to something else. It looks like nothing happened, but press the Home key once, and notice the solid (or dotted) line around the area you just selected. With the area still highlighted, click Print Area > Set Print Area from the same tab and group. Check both Horizontally and Vertically, then click OK. Press Tab again, and the cursor moves to the Center on Page panel. Then tab again down to Footer, and enter 0. Press the Tab key, cursor moves up to Header, enter 0. 25, press the Tab key, cursor moves to the Left field box. 25, then press the Tab key and your cursor moves to Bottom. TIP: It’s so much easier and faster to just tab and type through these settings, rather than trying to highlight each field box and cursor the up/down arrows. Press the Tab key once, and your cursor moves to the first setting: Top. The Margins tab in the Page Setup window appears. Next, click Margins from the same tab and group, and select Custom Margins from the list. Select the Page Layout tab, choose Orientation from the Page Setup group, and click Landscape. Cursor down to A2 and change the Row Height to 30.ġ-Select range, adjust column + row size. Move your cursor to the Home position, A1. Type 75 in the Row Height dialog box, and click OK. With the range still highlighted, select the Cells group, and click Format > Row Height. Type 18 in the Column Width dialog box, then click OK. From the Home tab, select the Cells group, and click Format > Column Width. Highlight Columns A through G, then roll your cursor down to extend the highlight through Row 7, making the range A1 through G7. After that, we’ll tackle several other projects for those who prefer to use Excel for graphics. This week, a calendar next week, note pads and lists.
#How to add calendar drop down in excel 2010 Pc
And, although Windows includes PC Paint as an Accessory program, it’s actually easier-in many cases-to use Excel for some projects. Not everyone has access to graphics and/or photo-editing software. If you’re wondering why anyone would use Excel over programs such as Photoshop and/or Illustrator, the answer is simple. You can make calendars, note pads, list pads, schedules, grid/graph paper, greeting cards, business cards, etc. With its graphic features, you can create anything from a detailed drawing to an edited photo. In addition to spreadsheets that calculate everything, it’s also a database, a programming tool, a graphics program with charts, tables, drawing tools, photos, clipart, and even layout abilities, and it’s a limited, but functioning, word processor (with a spell checker, Thesaurus, grammar tools, research capabilities, translation functions, and more). The answer is “almost anything.” Excel has evolved into one of the most versatile programs available. So, what else can Excel do? People ask this question all the time.
0 kommentar(er)
