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/01/05 22:08] – [clickable links from csv file] adminexcel_notes [2024/01/04 22:39] – [shortcuts I came across] raju
Line 11: Line 11:
 Ref:- Ref:-
   * https://docs.microsoft.com/en-us/office/troubleshoot/excel/files-open-automatically - low information density.   * https://docs.microsoft.com/en-us/office/troubleshoot/excel/files-open-automatically - low information density.
 +
 +===== useful links =====
 +==== 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
 +
 ==== sum values based on another column ==== ==== sum values based on another column ====
 <code> <code>
Line 54: 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|}}
 ===== Articles ===== ===== Articles =====
 ==== clickable links from csv file ==== ==== clickable links from csv file ====
excel_notes.txt · Last modified: 2024/01/04 22:42 by raju