Question about Microsoft Excel for PC

1 Answer

Continueous Printing I developed a worksheet based on data validation. When I wish to print required sheet, I have to select the number from Datavalidation popup. If I want to take printouts for all numbers' from datavalidation popup, what is the solution? Please help me. Regards Suresh

Posted by on

  • Anonymous Jun 02, 2008

    i have to create the dos on the bootup screen so it comes like a 2 os on the booting screen so please tell the correct soloution.

×

Ad

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

The best way is to write a small code in a macro. Basically you change the number in the datavalidation popup and print it automatically. If you want I can write you the code, but i will need the worksheet. Write me to lucho_lnc@yahoo.com

Posted on Mar 04, 2010

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 Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only 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 do I pull a figure from a spread sheet and add it to another in the same file.....


Are you talking about different worksheets in the same file.
go to the other worksheet then go to the particular cell and press = on keyboard
then use mouse to select the other worksheet from the bottom of the spreadsheet .
Then click on the cell you wish to link and press enter key on keyboard.

https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2
https://www.microsoftpressstore.com/articles/article.aspx?p=2447199&seqNum=2

You can also do this to spreadsheets with different file names by opening both spread sheets in different windows and switching between the windows.

you can also copy just the data by copy whole sheet (click on the square in top left hand and copy and then right click paste special on new worksheet - with values only rather than the original formulas from the spreadsheet

Jan 06, 2017 | The Computers & Internet

5 Answers

I have a Toshiba 3550 w/ malfunctioning mg-1003 10 bin sorter. I would like to disable the sorter and run without it. I was told to change system mode 4 from 1 or 2 to 0. It was already set to 0. Which...


Please check out these codes and descriptions, if they are ever helpful.
C01 Main motor drive problem C21 Optics problem Scan , lens, mirror C26 Exposure lamp detect problem C32 Setup error (UA) C41 Fuser thermistor, or no heat C43 Fuser thermistor problem or other fuser problem, after machine goes into ready C44 Heater problem C54 Communication problem between sorter and machine main board C55 Communication problem between ADF and machine main board C71 ADF drive problem C72 ADF registration sensor problem C73 EEPROM initialization problem C81 Sorter paper conveying motor C82 Sorter bin motor C83 Sorter upper sensor C84 Sorter lower sensor C85 Sorter home sensor C86 Sorter copy removal sensor C94 Optics initialization problem in test modes E01 Paper jam E02 Fuser jam E03 Paper jam E05 Paper feed jam E14 lower cassette jam E71, E72, E73 ADF jam E75 ADF jam of 2nd original E81, E82 Sorter jam
Good luck.

May 23, 2010 | Office Equipment & Supplies

1 Answer

Before printing several worksheets together I cannot pick out one sheet at random and print.


This is driver issue.

Go to the page you want to print. Do a File >Print and from within the driver screen select "Current Page". That should take care of it.

Don

Nov 23, 2009 | Epson Office Equipment & Supplies

1 Answer

Can't print line


Depending on what version of Excel you are using try the following:
The lines are called gridlines
  1. Click the worksheet.

  2. On the File menu, click Page Setup, and then click the Sheet tab.

  3. Select the Gridlines check box.
Note Large worksheets print faster if you do not select the Gridlines check box.

Please rate this solution...Thanks

Mar 24, 2009 | HP Officejet 5610 All-In-One InkJet...

1 Answer

Printing problem in xp


You probably need an Epson driver for Widows XP. Win 98 just isn't going to cut it for continuous forms printing.

Aug 12, 2017 | Epson DFX-9000 Dot Matrix Printer

1 Answer

Valid page names message driving me nuts


when printing specific pages the valid range is in this format 1,3,5,7,9,11 etc or if printing even numbers 2,4,6,8 etc or if printing specific pages 1,5,17,21,23,24,32 etc
what makes it a valid range is the comma between the numbers, no spacing and no full stop at the end
to further add confusion
when printing all of the pages just click all pages and it will print one sided all of the pages so no numbering is required
however if you want to save paper and reduce the size of the document
click pages 1,3,5,7,9,11,13 through to ,57
print those pages then turn them all around and upside down reinsert in the printer
now select pages 2,4,6,8 through to ,58 and print
that will give you printed data on each side of the paper in the correct page number order
to get to know how to reinsert the paper test with a print page 1 then reinsert and print page 2 to make sure that you have turned the paper the right way round

Jun 28, 2017 | Samsung ML-2510 Laser Printer

1 Answer

LINE 100


If Sale Line 100 is an Excel Template then it is simple.

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

Apr 25, 2008 | Computers & Internet

2 Answers

Unsure of correct formula


You can add a reference from the worksheet 1 to all other worksheets

Is it OK?

Mar 08, 2008 | Microsoft Excel for PC

1 Answer

Excel formula


Hi, I am not really sure if I get your exct meaning, so would I be correct in saying that you wish to copy all the data and structure from DCT INFO across to DCT. If this is correct so long as the dollar data is formatted in the first worksheet to currency then when it is pasted it will maintain its formating into the next sheet.

One question though...Do you wish to change the data on the DCT INFO sheet and wish it to be automatically changed in the DCT sheet?

If yes then you will have to write the following formula into the DCT cells:- =DCT INFO!A1 (where A1 is the first cell of data in sheet DCT INFO that you wish to duplicate.) You can then use auto fill by selecting the cell you just typed the formula in to and then placing the cursor onto the small black square in the righthand bottom of the cell and clicking the left mouse button and holding and dragging down to whereever your data ends. For example A30. Repeat this with the column B.
Let me know if tis is not entirelt what you require and I will try to help further.
Regards
SeaJade

Jan 09, 2008 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

89 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2909 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18411 Answers

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

Answer questions

Manuals & User Guides

Loading...