Differences

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

--- excel_notes [2023/01/05 22:06] – [format numbers] admin
+++ excel_notes [2024/01/04 22:39] – [shortcuts I came across] raju
@@ Line 11: / Line 11: @@
 Ref:-
   * 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 ====
 <code>
@@ Line 54: / Line 60: @@
 {{: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 =====
 ==== clickable links from csv file ====
@@ Line 97: / Line 117: @@
 $workbook->close();
 </code>
+==== [@] ====
+The @ symbol that precedes the column name of a table represents “this row”. So [@foo] means “the value in this row and column foo.”
+See "Using Formulas in Tables" section of [[http://apprize.info/microsoft/excel_9/10.html | Excel 2016 Bible]] which explains this syntax.
+{{tag>["columnar operations"]}}