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/02/14 23:57] – [commands I came across] rajuexcel_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 59: Line 60:
 {{:format_numbers_in_excel.png|}} {{:format_numbers_in_excel.png|}}
  
 +==== shortcuts I came across ====
 +
 +| 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.1676419022.txt.gz · Last modified: 2023/02/14 23:57 by raju