Question about Microsoft Office Excel 2007

1 Answer

Spreadsheet highlights When I try to highlight data on spreadsheets, it does not show on the screen. When I print the document, it just shows a grey color where it was highlighted, but not the color.

Posted by on

  • sfillat Apr 23, 2009

    I've tried resetting the palet, but that does not work. Since I did not see any option for "default" settings, I may not have reset it correctly.



    How exactly should I reset it?

  • sfillat Apr 24, 2009

    The latest suggestion did not work either. Do you have any other suggestions? Is there an online manual that I can look at?

×

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 122 Answers

You may have to reset your color palet, some program have black/white set as the default

Posted on Apr 23, 2009

  • Linda Goldsmith
    Linda Goldsmith Apr 23, 2009

    try tools/options and then pick colors try to edit and apply

×

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi,
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.
New users get 2 Free calls (no credit card required) and instant help on almost anything you can think of (from cars to computers, appliances, handyman, and even pets).
click here to download the app (for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to add comma in spreadsheet? thanks


To add commas to your spreadsheet you need the format the numbers. If you want your whole spreadsheet to use commas, click on the area to the left of column A and above number 1. This should highlight the whole spreadsheet. Click on the "," icon in the "number" area, and your spreadsheet will be formatted to put commas in.

Good luck,

Paul

May 06, 2016 | Casio Office Equipment & Supplies

1 Answer

How do I fix how my percentage shows on the excel spreadsheet?


On the home toolbar, there is a section titled "Number". That would be where you would change the format to whatever you want it to. Even Red..
So, all you have to do is enter in the number you want and Excel puts in the decimal point, or the dollar sign, or the percent sign for you. And you can even change the amount of decimal places you want it to go as well..

Highlight the cells/numbers you want to format, then go to the number section on the toolbar (edit), and select the format that you want.

May 15, 2014 | Microsoft Corporation Microsoft EXCEL 97...

1 Answer

Error code 20


The issue is typically caused if the printer is either not configured correctly, or your system tries to send an erroneous command to it. This error will typically show when you try and print a document / spreadsheet or another piece of data from your system, and will stop the print-out from proceeding. In order to fix this, it's advisable that you follow the steps outlined in this tutorial.

Aug 11, 2010 | HP Photosmart 2575 All-In-One InkJet...

1 Answer

Arrow keys moving whole page instead of cells


highlight a cell then try using the arrows

Dec 30, 2009 | Logitech 967437-0403 Keyboard

1 Answer

Change Font color in an excel spreadsheet and it prints correct color but will only show as black on screen.


Make sure you have highlighted yhe area you want to change the color on then click on the color you want and it should change for the screen as well as the printing phase of the program.

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

3 Answers

Transforming birthdates into year codes


Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

Aug 02, 2009 | Microsoft Office Excel 2007

1 Answer

I'm trying to print compact size directly from excel/word. What are the margins?


Step 1 Start Microsoft Excel and open an existing spreadsheet on which you would like to set the margins.
  • Step 2 Choose the "File" menu and click "Page Setup" to open the "Page Setup" dialog box. The "Page Setup" dialog box can be used to set up your page just how you would like it to appear.
  • Step 3 Click on the "Margins" tab at the top of the "Page Setup" dialog box to show the margins for the spreadsheet that you currently have option.
  • Step 4 Set the "Left," "Top," "Right," "Bottom," "Header" and "Footer" margins by clicking within the text box underneath each option to highlight the current margin setting.
  • Step 5 Type a new measurement for whichever margins you would like to change or use the arrows to move up and down throughout the measurements you can select for each option.
  • Step 6 Notice as you update each margin the preview in the center of the screen will change to reflect your new margin settings.
  • Step 7 Use your mouse to click the "OK" button to close the "Page Setup" dialog box and set the margins you have chosen for your current
  • Jul 07, 2009 | Computers & Internet

    2 Answers

    Printing a spreadsheet


    You should tell us your "Operating System, Spreadsheet Program and Printer" for us to give you a difinitive answer. Whithout this info I will attempt to give you a general answer.

    In your spreadsheet program, go to "File" and select "Page Setup" and set your paper size and set your margines and Portrait/landscape option. Your spreadsheet display should show you the paper limits for printing each page. Adjust the columns to the paper size. Highlight all the columns and rows you want to print. Find the menu option to set print area and click it. Now the computer will send the paged information to the printer and print as many pages as needed to cover the print area.

    May 31, 2009 | Apple Office Equipment & Supplies

    1 Answer

    Printer "out of memory"


    So which printer are you wanting help with?

    Nov 23, 2008 | Office Equipment & Supplies

    1 Answer

    Mail Merge Print Problem


    Was a recipient address created in an Excel spreadsheet or a database? Data needs to be pulled from somehwere to be added to the envelope.

    Dec 05, 2007 | Dell Latitude D800 Notebook

    Not finding what you are looking for?
    Microsoft Office Excel 2007 Logo

    Related Topics:

    81 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    2844 Answers

    Piyal Perera
    Piyal Perera

    Level 3 Expert

    528 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18402 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...