Microsoft Excel 2010 Logo

Related Topics:

A
Anonymous Posted on Aug 11, 2014

How to insert a vertical page break on wide spreadsheet

Spreadsheet is from column A to S. How do I print it on two A3 pages so it is readable?

5 Related Answers

Anonymous

  • 8 Answers
  • Posted on Sep 16, 2007

SOURCE: excel

If you remember the password, then all you need to do is select tools, unprotect worksheet and enter password

Ad

Anonymous

  • 90 Answers
  • Posted on Jun 18, 2009

SOURCE: I need a running balance in a column for a petty cash spreadsheet

Hi,

for Column E, if current cell is E(x) and previous cell is E(x-1) then,
formula will be:
=E(x-1) + C(x) - D(x)

logic: C is added to last balance, D is substracted the same way

Hope this helps.

Anonymous

  • 292 Answers
  • Posted on Nov 10, 2009

SOURCE: When I try to merge my excel document with 250

Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Testimonial: "At first I dismissed this assessment but when I checked my document I found the advice was correct, my problem is solved. Thank you. "

Anonymous

  • 2 Answers
  • Posted on Apr 21, 2010

SOURCE: setup multiple spreadsheet pages

Do you mean to display multiple sheets at the same time? Please check out the solution provided below (this applies to Excel 2003)

1.) To view multiple sheets in the active workbook, click New Window on the Window menu. Switch to the new window, and then click a sheet you want to view. Repeat for each sheet you want to view.

2.) On the Window menu, click Arrange.

3.) Under Arrange, click the option you want.

To view sheets in only the active workbook, select the Windows of active workbook check box.

Joseph Wright

  • 1729 Answers
  • Posted on Nov 10, 2013

SOURCE: when i open an excel spreadsheet, the columns go right to left instead of left to right.

  1. Click Options on the Tools menu, and then click the International tab.
  2. Do one of the following in the Right-to-left option group.
    • Click Right-To-Left to have new objects displayed in a direction familiar to right-to-left users.
    • Click Left-To-Right to have new objects displayed in a direction familiar to left-to-right users.

Testimonial: "This works for the spreadsheet I open, but how do I make this a fixed feature, so every time I open a spreadsheet, it reads left to right?"

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Page break insert

In an empty cell on sheet 1 press =
then click the cell that contains the first figure
press +
switch to sheet 2
click on the cell that contains the 2nd figure
press enter
go and look at sheet one and see the answer :-)

In my spreadsheet this cell now contains the formula
=A3+Sheet2!A1
0helpful
1answer

When printing spreadheet with multiple pages despite asking to print full spreadsheet the printer prints page by page and the resume button needs to be pressen for each page to print

Make sure that the the spreadsheet print settings match the printer settings. They have to be the same, else the printer settings most likely take priority. So when your print window comes up click on the (printer) 'options' (top right corner) and set those options according to the spreadsheet
0helpful
2answers

How to make a 7 row and a 7 coloum in a spreadsheet

Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep
    0helpful
    1answer

    I am unable to print excel spreadsheet - no facility to remove grid lines and as a result it wants to print a small spreadsheet into 666 pages

    I can see the page in excel with data i want to print but when i want to see the print preview or print the page, i am unbale to access the page. some fixed pages crops up for print preview or on printing the page
    0helpful
    1answer

    I want to print my spreadsheet in quattro pro 10 and i wnat the column titles to print on each page


    This is usually effected in the Print Setup screens where you are able to define the columns and rows that you want printed on each page.
    0helpful
    2answers

    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.
    0helpful
    1answer

    Printing excel attachments.

    Try downloading the file and then print it
    5helpful
    2answers

    Crooked Excel Spreadsheet

    I also had this problem, through trial and error I found that if you go into File, Page setup in excel then the Page tab, make sure the print quality is set to 600 dpi. Once I did that it printed correctly.
    0helpful
    1answer

    Printing-Supercalc 5-Spreadsheet-, Sideways

    just to check if the printer and the printer driver is working properly, try printing a 2 page document.

    if it prints out correctly - check the applications documentation / user guide for printing instructions.
    Not finding what you are looking for?

    46 views

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    Grand Canyon Tech
    Grand Canyon Tech

    Level 3 Expert

    3867 Answers

    k24674

    Level 3 Expert

    8093 Answers

    Brad Brown

    Level 3 Expert

    19187 Answers

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

    Answer questions

    Manuals & User Guides

    Loading...