Microsoft Excel Questions and Answers
Download Microsoft Excel eBook

Download PDF Download Microsoft Excel Questions eBook

Microsoft Excel Questions and Answers: Submit Your Question

1 :: How to Change the Sheet Tab Color of Excel Spreadsheets?

In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the color of worksheets tabs containing related information can make it easier to navigate through very . Or to use tab colors to differentiate between sheets containing unrelated information.
Is This Answer Correct?    80 Yes 16 No
Submit Your Answer

2 :: Show Excel Toolbars on Two Rows?

The default setting for Excel toolbars is to display them on a single row, thereby hiding many of the toolbar buttons. It is quite easy to change the default settings to show Excel toolbars on two rows, making for a easier time formatting your spreadsheet.
Is This Answer Correct?    32 Yes 9 No
Submit Your Answer

3 :: Upload data from Excel into SAP?

* Some of the Business functions (BAPI's / RFC unctions) offer data upload
* The general tool in SAP for data upload is the Batch input / call transactions

In the batch input file you specify screen by screen and field by field the input to SAP.

SAP has a recorder to create the sample file. Just run trans SHDB. Within this transaction, you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel. Manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.
Is This Answer Correct?    13 Yes 5 No
Submit Your Answer

4 :: What are Excel Spreadsheet Number Formats?

Number formatting in Excel spreadsheets is used to change the look of the numbers in the cell. The most common formatting options are currency, comma, date, accounting and percent, although there are more options available.
Is This Answer Correct?    25 Yes 2 No
Submit Your Answer

5 :: How Do You Use the SUM and AutoSUM Functions in Excel?

The Excel SUM function is probably the most often used function in Excel spreadsheets. The AutoSUM button on the Standard toolbar makes it easy to quickly sum columns or rows of adjacent data without actually typing in the cell references.
Is This Answer Correct?    25 Yes 2 No
Submit Your Answer

Place Your Question