Question about Microsoft Office Professional 2007 Full Version for PC

3 Answers

Excel 2007 How to change the color of Grid line in Excel 2007?

Posted by on


3 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 265 Answers

Excel 2007 - default.aspx?assetid=za790050001033Show All Hide All

  1. Select the sheets on which you want to change the gridline color. How?
    When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.
    To select Do this A single sheet Click the sheet tab. If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab.
    default.aspx?assetid=za060521061033 Two or more adjacent sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet. Two or more nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.). Note If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.
    default.aspx?assetid=za790050001033Cancel a selection of multiple sheets
    To cancel a selection of multiple sheets in a workbook, click any unselected sheet.
    If no unselected sheet is visible, right-click the tab of a selected sheet. Then click Ungroup Sheets on the shortcut menu.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, click the color you want in the Color box. To use the default gridline color, click Automatic.

Posted on Jan 20, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 146 Answers

Highlight the grid area you wish, right click, format cells, borders, click on outside borders / inside /both buttons ( as appropriate ), choose colour from palate.

Posted on Jan 18, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert whose answer got voted for 500 times.

  • Master
  • 4,402 Answers

Go to format > style >modify> border and then color
to set cell color same steps but do patterns

Posted on Jan 18, 2008

1 Suggested Answer

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

How to change the color of the cell in excel if the date has lapse already



Aug 31, 2011 | Microsoft Office Excel 2007

1 Answer

What is the meaning of rows?

In Microsoft Excel, "rows" refer to data cells grouped together horizontally across a single line. The numbers on the far left of the screen refer to a row number. Similarly, the letters at the top of the workbook page refer to the columns.

Here is a picture to help:

In this example, there are 3 rows. All the cells in Row 1 contain the words "Row 1" and are color-coded orange. Likewise, All the cells in Row 2 are pink, and those in Row 3 are blue. Do note, however, that even though the boxes under the letter "F" aren't color-coded, they are still in the respective rows. Each color-coded line could extend for an infinite number of boxes, and each box of the same color would be part of that row.

If you find this solution helpful, please leave a positive rating!

Jun 22, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

How i adjust horizontal size and vertical size

To answer your concern, all you have to do is to change the setting of your aspect ratio on your TV.

Here is my suggested way to procede:

1. Apply 1080i signal, which should produce an oversized HD image on ColorStream1or 2.
2. Select an HD channel that is broadcasting standard 4:3 image, not wide screen.
3. Switch to the Service Mode ( Please refer to the above links). In the Service mode, press channel up/down to find the Adjustment parameters needed for the following steps.

4. Adjust HIT with volume up/down control for the image height to 22.5 inches.

6. Adjust WID for image width of 30 inches, (22.5*4/3)
7. Adjust HPOS to center the image.
8. Adjust PARA and TRAP to minimize geometric distortion.
9. Switch into Convergence mode and Adjust VLIN to get equally spaced horizontal grid lines.
10. Measure the length of the central grid lines and note the number of horizontal and vertical grid lines. This information is used to create an overlay grid.
11. Create the overlay grid on 40x25 x0.003 inch clear Acetate sheet, which you can get at the Art Supply store for under $2. Draw the grid with a fine line erasable pen. Draw vertical and horizontal lines through the center of the sheet so that the lengths are the same as the central grid lines. Now draw the grid so that it has the same number of lines as the convergence grid but are equally spaced, with the outer ones at the ends of the central lines.
12. Cut off about 1/4 inch from the right side of the sheet so that the sheet can lay flat against the screen, which is slightly less than 40 inches.
13. Put a reference mark on the TV frame 2.5 inches down from the upper left side of the screen.
14. Place the overlay on the screen so that the upper edge lines up with the reference mark. The overlay sticks by electrostatic attraction.
15. Use convergence controls to remove grid distortion and converge grid colors. Refer to the Anamorphic link for details.
16. Enjoy 1080i.

Other Comments:
I didn't realize I could create the overlay grid before placing the Acetate sheet on the TV screen, until I finished drawing the grid with the sheet placed on the screen. I added grid lines as called for in the procedure. I'm sure this method took much longer no only to draw the lines but some of them were difficult to see.

Part way through the convergence procedure, I became concerned that the image width was off since I did my screen adjustment with wide screen image. Thus, I decided to repeat that step with a 4:3 screen.

I confirmed the need to press 7 often to save results since after I adjusted one grid color without it, I accidentally hit a key that switched me out of convergence mode and when I switched back, all settings were gone.

Another mistake I made was not realizing that the cursor color determines which grid gets moved.

May 13, 2011 | Toshiba 32AV500U 32 in. LCD HDTV

1 Answer

I have to list a number of name, phone number and email address together. How do I do that? And what program do I use?

You can use word or excel depending on how you want the finished product to look. In excel you can use grid lines to make easier reading. The cells or boxes are adjustable in size so you can change them as you go. If you naver used your excel or word your programs will have a tutorial in it, you should watch this and it will teach you the basics so you can get started and experiment as you go if you like. HP and Microsoft also offer free on line classes if you like what your doing and would like to take advanced classes to learn more. Have fun and type your paper it will be easier than you think.

Oct 14, 2009 | Microsoft Windows XP Home Edition

2 Answers

Microsoft office 2007 excel problem when i save excel files then i coulnd not save a file , because there some tmp error

Just re-install the excel only using your ms office 2007. Once you put the installer on the drive it will give an option on what office you want to install, just select excel.

Nov 25, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Sharing Problem

some colors are not available in office 2003

under (office 2007) excel options (alt-t-o), save tab, you can choose which colors will be seen in previous excel versions.

Sep 23, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Forgot password to open Excel sheet

If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

MS Excel 2007 SERIES function

First thing: Have yo downloaded *all* the updates available for Office 2007 from Windows Update?

Mar 17, 2008 | Computers & Internet

1 Answer

Adjusting convergence grid

i correct grid will look all white. all colors aligned up.
you should be able to move the lines with the remote. and you cant burn anything out by doing convergence.

Jan 27, 2008 | Samsung HC-P4752W 47" Rear Projection...

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

152 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides