0
A worksheet in Excel is able to display more columns and rows if?
Wiki User
∙ 6y ago
If you change the scale, zooming out to show more.
Wiki User
∙ 6y ago
Add your answer:
Earn +20 pts
If you shrink a worksheet will excel be able to display more columns?
probably
How you copy the document acrobat reader to ms Excel sheet?
You do not, unless you have Acrobat or some other software that can edit PDF files. An acrobat PDF file is basically a picture of the document. If you can edit the file, sometimes you can SaveAs, but if all you have is a PDF file and MS Excel, you will not be able to convert to a worksheet. You can, however, import as an object into Excel and display the page in a worksheet. This will be the same as importing an image; you can display the image, but you will not be able to edit the contents.
How do you change a jpg file to an Excel file?
You can't. JPG is pictures, excel is a worksheet with names and numbers. You might be able to turn an excel-file into a JPG, but then you would no longer be able to do calculations in the worksheet.
How do you display a list of statistical worksheet functions in Excel?
Click on the fx button and you can then choose the different categories of functions. Amongst those will be the statistical ones. If you choose them you will be able to see a list of the statistical functions.
What is a grid in Excel?
When you look at a worksheet in Excel you can see all the cells, because of the lines around them. Those are gridlines. You can also add borders, to make heavier lines around cells. Gridlines can be turned off completely, by going to the Options menu and the View section and removing the tick beside Gridlines.
If Excel Merge and center is disabled how to enable it?
Unprotect the page where you want to use the Merge and Center command. When a worksheet is protected, you will not be able to use any of the commands that change the appearance of the worksheet.
What does hide and unhide do in Excel?
Hide and unhide literally do what they say. They enable you to hide and unhide rows and columns on a worksheet. Sometimes you may have some data on a worksheet that is needed, but does not have to be seen, so it can be hidden. A formula that is important on the sheet may be based on another formula, that does not need to be displayed. You may want to hide data that supports a formula. There may be data that you do not want users to see, which will prevent them from editing it or even deleting it, which may affect other formulas. For these and lots of other reasons, sometimes it is useful to be able to hide rows and columns in a worksheet, so this option is available.
How do you sort linked data in excel?
You are able to sort linked data within any Excel document. If an error does occur check each columns formula so there Is agreement.
Which software allows editing of a cell?
The question and categories are not clear. If the question relates to Microsoft Excel, you can edit worksheet cells using MS Excel. If the question relates to Cells and Genetics, you will not be able to find software to edit a biological cell.
In Excel can you create a worksheet that will be able to make decisions based on the information that appears in other cells?
Yes you can do that. The main function to do that is the If function. See the link below for more information on it.
How do you select all columns and rows that have data in them within excel?
Press the F5 key. Then press click Special on the dialog box that opens. You will then be able to select types of data and formulas to find and be able to select them.
How do you determine the formulas and functions needed for a worksheet in Excel?
There is no simple answer to that. Each worksheet is different. It depends on what it is that needs to be done, so they will have different formulas every time. A person who knows how to use Excel and knows what needs to be calculated, will be able to create the formulas. There are different ways of doing the same thing, so it is possible to use different variations of formulas that will achieve the same result. So, as you can see, there is no straightforward answer. It is down to the knowledge and experience of the person creating the worksheet as to what formulas they will use.
