Keeping leading zeros and large numbers - Microsoft Support
Do you ever import or enter data in Excel that contains leading zeros, like 00123, or large numbers like 1234 5678 9087 6543? Examples of these are social security numbers, phone numbers, credit card numbers, product codes, account numbers, or postal codes.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Scale a worksheet - Microsoft Support
In Excel, you can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.
Insert page numbers on worksheets - Microsoft Support
You can insert page numbers on multiple worksheets in your workbook by using the Page Setup dialog box. For example, if your workbook contains two worksheets that are both two pages long, the first worksheet will contain two pages numbered 1 and 2. The second worksheet will also contain two pages numbered 1 and 2.
Change the scale of the vertical (value) axis in a chart
Change the scale of the vertical (value) axis in a chart. Applies To. By default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
How to correct a ##### error - Microsoft Support
Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
Accessibility best practices with Excel spreadsheets
Best practices for making Excel spreadsheets accessible. Check accessibility while you work in Excel. Create accessible tables. Use an accessible template. Add text to cell A1. Add alt text to visuals. Add accessible hyperlink text and ScreenTips. Use accessible font format and color. Create accessible charts.
Available number formats in Excel - Microsoft Support
Available number formats in Excel. In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers. Select a cell or a cell range. On the Home tab, select Number from the …
CELL function - Microsoft Support
This formula calculates A1*2 only if cell A1 contains a numeric value, and returns 0 if A1 contains text or is blank. Note: Formulas that use CELL have language-specific argument values and will return errors if calculated using a different language version of Excel.
Create a PivotTable to analyze worksheet data - Microsoft Support
How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.
Change the format of a cell - Microsoft Support
Change the format of a cell. You can apply formatting to an entire cell and to the data inside a cell—or a group of cells. One way to think of this is the cells are the frame of a picture and the picture inside the frame is the data.