Question about Computers & Internet

1 Answer

Excell Hi there I changed from excell 2000 to 2003 and has the following problem. When I have 1 sheet but with two pages and on the first page is a date and I want this date to appear on the second page I have to add a formula. I now want to change the first page's date and want the second page to change automatically. What do I do?

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 226 Answers

If you want to put dates, comments, etc.

you can type wht ever you want in the page.

go to page options then to header and footer

Posted on Jan 28, 2008

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.
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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Remove page breaks in excel


We would appreciate if you share with us your Excel version as well so that we can give you a more specific solution to your issue. In the meanwhile, you can refer to the following steps to delete a manually-inserted page break in Excel 2007, Excel 2010, or Excel 2013:

(Important: You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks.)

1. Select the worksheet that you want to modify.
2. Go to "View" tab, then go to "Workbook Views" section, and click "Page Break Preview".
(Note: You can also click "Page Break Preview " on the status bar)
(Important: If you get the "Welcome to Page Break Preview" dialog box, click "OK". To avoid seeing this dialog box every time you go to "Page Break Preview" view, select "Do not show this dialog again" check box and click "OK".)
3. Now do one of the following:
a) To delete a vertical page break, select the column to the right of the page break that you want to delete.
b) To delete a horizontal page break, select the row below the page break that you want to delete.
(Note: You cannot remove automatic page breaks)
4. Go to "Page Layout", then go to "Page Setup" section, and click "Breaks"
5. Click "Remove Page Breaks"
(Important: You can also remove a page break by dragging it outside of the page break preview area {to the left or right for vertical page breaks, or up or down for horizontal page breaks}. If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled. To check the status of your drag-and-drop feature, click office button , click "Excel Options" tab, click "Advanced", go to "Editing Options" and make sure you have checked the "Enable fill handle and cell drag-and-drop" option.)

To refer to a pictorial explanation of the above steps, you can refer to "Delete a manually inserted page-break" section on the following Microsoft Support Page:
http://office.microsoft.com/en-in/excel-help/remove-a-page-break-HA102576899.aspx?CTT=1

GuruAid.com

Jun 22, 2014 | Computers & Internet

1 Answer

My excel is starting right to left in window 7


The default worksheet direction in Excel 2007 or 2010 is Left-to-Right. To change a worksheet direction to Right-to-Left, follow these steps:
  1. In Excel Ribbon click on the Page Layout tab.
  2. In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.
xl10rtl1-300x53.jpg
- See more at: http://www.exceldigest.com/myblog/2012/04/29/how-to-change-worksheet-direction-in-excel-2010-to-right-to-left/#sthash.lSG25YXq.dpuf

May 27, 2014 | Microsoft Excel 2010

1 Answer

How to connect tally with excel file? sir/madam i want to connect my tally erp 9 with my stock (excel file) i maintain the inventory in tally, when i make a bill on tally on that time it automatically...


hi

deepu

in tally 9 ERP has a oprtion to export any date from tally to excel just open that page which u want to open in excel

then see on the top in tally page there is option for export file just folwothat u will able to export dot in to excel

Jun 26, 2010 | Peachtree Software Peachtree Complete...

1 Answer

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.

Apr 12, 2010 | Microsoft Excel for PC

1 Answer

I cant print on A3 paper through microsoft excel on hp1280


in excel sheet please change the page size to A3 and try to print ..... if you are using office 2007 go to page layout then go to size icon there change the page size to A3 and check .......... if you are facing the same problem please post your comment ............. while you giving print please select the document which one you want to print ..........

Dec 31, 2009 | HP DeskJet 1280 InkJet Printer

1 Answer

Excel formula related to a date range


Use the IF and Date functions together. On sheet 3, put the birthday (3/15/1954) in cell B1, put the beginning date (1/1/1946) in cell C1 and the ending date (12/31/1964) in cell D1.
Then on Sheet 1, but the following formula in the cell you want an X to be placed in.
=IF(AND(Sheet3!B1>=Sheet3!C1,(Sheet3!B1<=Sheet3!D1)),"X"," ").
Make sure you type the formula Exactly as it appears.

Mar 20, 2009 | Oracle Database Enterprise Named User Plus

2 Answers

Copy-paste


it should be

=7/4  or =100/30
and excel will give you a numeric result.

Oct 18, 2008 | Microsoft Excel for PC

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet


you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Computers & Internet

1 Answer

Excel Formulas


Hi,
Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link
http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Feb 05, 2008 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

95 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...