Results 1 to 5 of 5

Thread: excel problme

  1. #1
    masif's Avatar
    masif is offline Senior Member+
    Last Online
    13th February 2017 @ 01:45 PM
    Join Date
    21 Jan 2009
    Age
    38
    Posts
    1,280
    Threads
    218
    Credits
    522
    Thanked
    10

    Default excel problme

    meri problume ye hai ke main jab bhi excel main koi sheet waghera banata hoon to ban to jati hai mager us ka printout nahi nikalta mera matlab hai ke
    pura nahi nikalta yani main ne sheet 9 columes ki banai hai mager printout sirf 6 columes ka nikalta hai colume name f tak sheet nikalta hai mazeed nahi nikalta plz help me

  2. #2
    nom is offline Senior Member+
    Last Online
    10th February 2016 @ 11:14 AM
    Join Date
    30 Jan 2009
    Posts
    238
    Threads
    39
    Credits
    0
    Thanked
    6

    Default

    Printing in Excel - Overview



    Printing in Excel is a bit different than printing in some other programs, such as a word processor. One of the main differences is that Excel has five locations in the program that contain print-related options.

    The first, the Print button, is located on the standard toolbar. The other four of these are listed under the File menu:

    * Print Preview
    * Page Setup
    * Print Area
    * Print

    The Print Button


    Excel Printing using the Print button

    If you want to quickly print out the worksheet that is open in the Excel screen, you can do so by using the Print button on the standard toolbar. Clicking on this button sends the active worksheet directly to the printer, using the current print settings.

    Use this button when you want to print a single copy of a workbook. Just realize that, unless you have previously set a Print Area, you are going to get all the sheets in the workbook that contains data, not just the sheet that is on the screen.

    Using Print Preview



    Excel Printing Using Print Preview

    Before printing all or part or an Excel spreadsheet, it might be a good idea to have a look at what is going to get printed – just in case it’s not what you expect – or really want. Print Preview displays the current worksheet in the preview window. It shows you how the worksheet will look when it is printed.

    Print preview toolbar

    Some of the more commonly used options on this toolbar are:

    * Next and Previous buttons – Show you all the pages that will be printed.
    * Zoom – Allows you to zoom in on specific parts of the worksheet.
    * Setup – Opens the Page Setup dialog box,
    * Print – Opens the Print dialog box.

    Excel Page Setup Dialog Box Page Tab



    Printing in Excel - Using the Page Setup Dialog Box

    The page tab in the Page Setup Dialog Box has three areas of printing options.

    1. Orientation – Allows you to print sheets sideways (Landscape view). Very useful for spreadsheets that are just a bit too wide to print using the default portrait view.

    2. Scaling – Allows you to adjust the size of the worksheet you are printing. Most often used for shrinking an Excel worksheet to fit on fewer sheets or magnifying a small worksheet to make it easier to read.

    3. Paper Size and Print Quality
    * Paper size – is adjusted most often to accommodate larger worksheets such as changing from the default letter size (8 ½ X 11 inches) to legal size (8 ½ X 14 inches).

    * Print quality – has to do with the number of dots per inch (dpi) of ink that are used in printing a page. The higher the dpi number, the higher the quality the print job will be.

    Excel Page Setup Dialog Box Sheet Tab



    Excel Printing - Using the Page Setup Dialog Box (con't)

    The Sheet Tab of the Page Setup Dialog Box has four areas of printing options.

    1. Print Area – Select a range of cells on the spreadsheet to print. Very useful if you are interested only in printing a small section of the worksheet.

    2. Print Titles – Used for printing certain rows and columns on every page - usually headings or titles.

    3. Print- The most commonly used options are -
    * Draft quality – Prints a quick, low quality draft copy.

    * Gridlines – For printing the worksheet gridlines – making it easier to read data on larger worksheets.

    * Row and column headings – Prints the row numbers and the column letters down the side and across the top of a each worksheet.

    4. Page order – Changes the order for printing pages on a multiple page spreadsheet. Normally Excel prints down the worksheet. If you change the option, it will print across.

    Setting and Clearing a Print Area



    Excel Printing - Setting and Clearing a Print Area

    By default, Excel prints the entire worksheet. One way to stop this is to set a print area, which specifies the exact range of cells to print.

    To set a print area –

    1. Drag select the group of cells you want included in the print range.
    2. Choose File > Print Area > Set Print Area from the menu.
    3. Choose File > Print Preview from the menu to check that the print area is set correctly.

    To remove a print area -

    1. Choose File > Print Area > Clear Print Area from the menu.
    2. Choose File > Print Preview from the menu to check that the print area has been cleared.
    n O m
    Why is it drug addicts and computer aficionados are both called users?

    Beautiful Islamic Screen Savers








  3. #3
    nom is offline Senior Member+
    Last Online
    10th February 2016 @ 11:14 AM
    Join Date
    30 Jan 2009
    Posts
    238
    Threads
    39
    Credits
    0
    Thanked
    6

    Default

    The Print Dialog Box



    Excel Printing - The Print dialog box

    The four main option areas in the Print dialog box are:

    1. Printer – Allows you to choose which printer to print from. To change printers, click on the down arrow at the end of the Name box and chose from the printers listed in the drop down menu.

    2. Print range
    * All – The default setting – refers only to pages in the workbook containing data.
    * Pages – List the start and end page numbers for those pages to be printed.


    3. Print what?
    * Active Sheet – The default setting - prints the worksheet page that was on screen when the Print dialog box was opened.
    * Selection – Prints a selected a range on the active page.
    * Workbook – Prints pages in the workbook containing data.

    4. Copies
    * Number of copies
    * – Set the number of copies to be printed. Collate – If printing more than one copy of a multi page workbook, you can choose to print copies in sequential order.

    FINISH

  4. #4
    masif's Avatar
    masif is offline Senior Member+
    Last Online
    13th February 2017 @ 01:45 PM
    Join Date
    21 Jan 2009
    Age
    38
    Posts
    1,280
    Threads
    218
    Credits
    522
    Thanked
    10

    Default

    mere pas m s office 2003 hai meri samajh main nahi aaraha
    app plz urdu main samjadain ge plzzzzzzzz

  5. #5
    n2cute is offline Advance Member+
    Last Online
    29th May 2017 @ 11:20 AM
    Join Date
    12 Dec 2007
    Location
    Lahore
    Age
    37
    Gender
    Male
    Posts
    2,503
    Threads
    133
    Credits
    453
    Thanked
    8

    Default

    nom brother great work

Similar Threads

  1. C.P.U Problme
    By Waseem_R_N in forum Ask an Expert
    Replies: 5
    Last Post: 20th July 2014, 08:35 PM
  2. my net problme Plz help me
    By mtariqtsk in forum Ask an Expert
    Replies: 18
    Last Post: 8th July 2013, 09:27 AM
  3. Help Me Mic Problme
    By Banto5 in forum Ask an Expert
    Replies: 6
    Last Post: 15th January 2013, 07:13 PM
  4. Usb Problme :PLz Help me
    By mtariqtsk in forum Ask an Expert
    Replies: 12
    Last Post: 17th March 2012, 12:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •