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
Last revisionBoth sides next revision
excel_notes [2023/03/13 13:58] – [format numbers] adminexcel_notes [2024/01/04 22:39] – [shortcuts I came across] 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|}}
 ===== Articles ===== ===== Articles =====
 ==== clickable links from csv file ==== ==== clickable links from csv file ====
excel_notes.txt · Last modified: 2024/01/04 22:42 by raju