0
What else can I help you with?
What is erasing format in Microsoft Excel?
It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.It is removing normal formatting on a cell. The Clear All formatting option is often used to do this.
What formatting option can be used to stop text from going outside of it's cells borders?
I assume you mean in Excel, or similar spreadsheet programs. In Excel, you can use the "Word Wrap" option, which you find under cell format. In that case, if there is too much text in the cell the row height will grow to make more room below.
Can you used the wrap text option for long labels in Excel?
Yes.
What is a cell cursor?
A cursor that is used when selecting a whole cell in an excel spreadsheet.
Can filter option be used for rows in excel?
No but you can transpose the data and filter on the columns.
Which short cut key is used to select the top leftmost cell of the Excel sheet?
Ctrl-Home will bring you to cell A1 in a worksheet in Excel.
Can a period name a cell in Excel?
If you a mean a period as in a dot, then no it cannot be used to name a cell.
Which feature in Microsoft Excel enables you to identify the compatibility of objects used in XLSX workbook when it is saved in earlier version of Excel?
the publish option
How do you replace all text all at once in Microsoft Excel?
The Find and Replace option can be used to replace text in Excel. A particular piece of text can be replaced throughout the document using Replace All. Use Ctrl - H to activate the Replace option in Excel.
How do you extract file and folders name in Excel?
If you mean for the current file, you could use the CELL function and its filename option like this: =CELL("filename",A2) This will give you the name and folders for the file. It can also be used to get the details by referencing a cell in another file. =CELL("filename",'C:\[ABc.xls]Sheet1'!$A$5)
What is a formula bar used for in Excel?
To enter the formula in selected cell, To view the farmula or content of selected cell.
What ribbon is used to add cell borders and shading to a cell in Excel?
There is only one ribbon in Excel. It has multiple tabs. The options for borders and shading are in the Font group on the Home tab.
