User Tools

Site Tools

Trace:
excel_notes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
excel_notes [2023/03/13 13:58] – [format numbers] adminexcel_notes [2024/01/04 22:42] (current) – [format as numbers] raju
Line 14: Line 14:
 ===== useful links ===== ===== useful links =====
 ==== dummy ==== ==== dummy ====
 +  * refresh pivot table data - https://support.microsoft.com/en-us/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2
   * sort values in a pivot table - https://support.microsoft.com/en-us/office/sort-data-in-a-pivottable-or-pivotchart-e41f7107-b92d-44ef-861f-24430830450a   * sort values in a pivot table - https://support.microsoft.com/en-us/office/sort-data-in-a-pivottable-or-pivotchart-e41f7107-b92d-44ef-861f-24430830450a
  
Line 62: Line 63:
  
 | insert multiple lines in excel cell | Alt + Enter | | insert multiple lines in excel cell | Alt + Enter |
 +
 +==== format as numbers ====
 +''Ctrl + Shift + !'' will apply number format.
 +
 +For example, let's say we have
 +
 +{{:before_applying_number_format.png|}}
 +
 +Select columns A and B. Press ''Ctrl + Shift + !''. We will then get
 +
 +{{:after_applying_number_format.png|}}
 +
 +See also:
 +  * https://www.myonlinetraininghub.com/excel-shortcuts - shows many short cuts. The ''Ctrl + Shift + !'' shortcut is listed in the 'Number Formatting' section.
 ===== Articles ===== ===== Articles =====
 ==== clickable links from csv file ==== ==== clickable links from csv file ====
excel_notes.1678715939.txt.gz · Last modified: 2023/03/13 13:58 by admin