excel_notes
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
excel_notes [2023/01/05 22:08] – [clickable links from csv file] admin | excel_notes [2024/01/04 22:42] (current) – [format as numbers] raju | ||
---|---|---|---|
Line 11: | Line 11: | ||
Ref:- | Ref:- | ||
* https:// | * https:// | ||
+ | |||
+ | ===== useful links ===== | ||
+ | ==== dummy ==== | ||
+ | * refresh pivot table data - https:// | ||
+ | * sort values in a pivot table - https:// | ||
+ | |||
==== sum values based on another column ==== | ==== sum values based on another column ==== | ||
< | < | ||
Line 54: | Line 60: | ||
{{: | {{: | ||
+ | ==== shortcuts I came across ==== | ||
+ | |||
+ | | insert multiple lines in excel cell | Alt + Enter | | ||
+ | |||
+ | ==== format as numbers ==== | ||
+ | '' | ||
+ | |||
+ | For example, let's say we have | ||
+ | |||
+ | {{: | ||
+ | |||
+ | Select columns A and B. Press '' | ||
+ | |||
+ | {{: | ||
+ | |||
+ | See also: | ||
+ | * https:// | ||
===== Articles ===== | ===== Articles ===== | ||
==== clickable links from csv file ==== | ==== clickable links from csv file ==== |
excel_notes.1672956514.txt.gz · Last modified: 2023/01/05 22:08 by admin