(Giving Chuck Pearson Some Pointers)

Don Edrington's Home Page
Brief Bio     Shy Guy from Hollywood High     Mission Statement

PC Chats for: 2002 & 2003 & 2004 & 2005

Don is occasionally available for onsite tutoring. (949) 646-8615

gif.gif Music Page

How to Create a Repetitive Set of Headers in a Spreadsheet

Let's start with a super simple example. Suppose you wanted a table whose headers only listed weekends (i.e. Saturday and Sunday). Type Saturday (or Sat) into a cell. Grab the little black square in the cell's lower-right corner and drag it one cell to the right. (Or - you could drag it down one cell, if you wanted your table arranged vertically.)

Notice how the "dragged across" cell now reads Sunday (or Sun).

Now copy and paste these two cells into the next two cells (to the right or downwardly) thus giving you headers that read: Saturday, Sunday, Saturday, Sunday (or Sat, Sun, Sat, Sun).

Finally, mouse select all four cells and grab the black square in the second Sunday (or Sun) cell, and drag it as far as you want. See how easy this was?

Well, the same principal works with Monday thru Friday headers (or Mon thru Fri) horizontally or vertically. Try it - you'll like it!


Back to Don's Home Page        Don's "Oldies But Goodies" Music Page

Letter from PC Technician Prof. Carl Von Papp
Problems with Creating a "Boot Disk" for Windows XP

Microsoft does NOT support creating a bootable floppy in WinXP. I really don't know why they even have it as part of WinXP. It's useless. It won't work. The reason is simple.

When you create a bootable floppy using the method outlined in your article, it will ONLY create a Windows 98 ME disk and not a WinXP disk. When you try to boot up on this disk you will be amazed to find that your C:\ drive has disappeared. The reason is simple. If you have converted your file system to NTFS, Win 98SE and ME can't recognize the NTFS partition.

If you are using the FAT32 File System booting up on this disk will work, but it's still worthless as there is no way to access your CD ROM drive if you need to reinstall Windows.

The only way to properly boot up if you are having problems is to boot up on the WinXP install disk and PRESS R to go into the recovery console.

Some name brand computers do not have a WinXP install disk, but there is a way to create a bootable floppy. It's complicated and can only be created by computerists who are technical. Microsoft does not support this. I can send you the method as an attachment if you want this information.

                                                                      Carl A. Von Papp - Bellevue Community College

Letters from Readers Regarding
Changing Page Numbering Styles in MSWord

From: Lois Stewart-Morse

I think I have an answer to Ed Wohlford’s question about changing from Roman Numerals to Arabic numbers.

He should create the number of pages that he wants and set up for Roman numbers (16 pages), for instance. Then create the 17th page and go to File, Page Setup, Margins. Then select Apply to “this point forward” and then go back to Insert and set up for Arabic numbers. It will begin at numeral one unless you tell it differently.

From: Nancy Pasulka

I'm sure you received numerous answers on this, but here's my version.

After you hve numbered the first group of pages, got to insert, section break. You will hve options about continuing with some other choices at that screen -- if the page numbering choice does not come up, after you have selected section break, go to insert page numbering and on the tool bar there is a little button that says something like "same as previous." Click it off. You should then have the page numbering in your second section. Be sure however, not to select anything that will affect the rest of the pages if you don't want those choices!

From: Bill Peters

Changing page numbering format in Word is easy when you break the document into sections. Each section can have different page numbering format. Create a "Section Break" where the change is to occur and format the page numbers in the header or footer as desired using "Insert/Page Numbers/Format".

From: Gerri Jellison

1. Insert Page Numbers and format them in the Roman Numeral style, placing them where ever on the page.

2. To change from Roman Numeral to Numerals....

Put your cursor at the top of the page that you want to start numbering with "regular numbering".

Click Insert, Break and click on the radio button Continuous - Click OK

Highlight the text that you wish to have numbered "normally" (i.e. page 17 and forward in Ed's document)

Click File, Page Setup and under Preview, choose Apply To, Selected Text.

Click OK and OK to close out the file menu

Go back to Insert Page Numbers, click Format

Click on radio button beside Continue from previous section

Go up to the top of the page and under Number Format, select the regular numbering (1,2,3)

Click on OK and close out.

You will see the numbers 1-16 in Roman and 17-?? in Arabic.

This really is much simplier than it sounds. The most important step to remember is the Insert Break Continuous or you will get a blank page between your roman numerals and arabic and that page will have a page number and if you click to delete that page than your whole document will accept the last number format (i.e. arabic).

Comments or questions about this page can be emailed to
(After clicking the email link, please type in com to complete the address.)
(Top of Page)