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.

×

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

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

Posted on Jan 02, 2017

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

1 Answer

How to print database in vb


To Print a Database you would require to create a Report. There were many ways of creating reports in Visual Basic 6.0. Hereby I am giving you an example of Data Report.
Printing a Data Report
Printing a data report can be accomplished in one of two ways. The user can click the Print button that appears on the data report in Print Preview mode (using the Show method), or you can programmatically enable printing using the PrintReport method. If an error occurs during printing, trap it in the Error event.
Choosing to Display a Print Dialog Box
When printing a report programmatically, you have two choices: to print by displaying the Print dialog box, or by printing without displaying the dialog box.
To display the Print dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code.
DataReport1.PrintReport True The Print dialog box allows the user to select a printer, print to file, select a range of pages to print, and specify the number of copies to print.
Note Printers must be installed on the computer in order to present a choice of printers.

Printing Without a Dialog Box
In some cases, you may wish to print the report without user intervention. The PrintReport method also gives you the option of selecting a range of pages to print, either all, or a specified range.
To print without displaying the dialog box
  1. Add a CommandButton to a Form.
  2. In the button's Click event, place the following code:
DataReport1.PrintReport False
Or, to specify a range of pages to print, use the code below:
DataReport1.PrintReport False, rptRangeFromTo, 1, 2

Mar 11, 2014 | Microsoft Visual Basic 6.0 for PC

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

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

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?
Microsoft Excel for PC Logo

Related Topics:

86 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18346 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...