LogFAQs > #958417913

LurkerFAQs, Active DB, DB1, DB2, DB3, DB4, DB5, DB6, DB7, DB8, Database 9 ( 09.28.2021-02-17-2022 ), DB10, DB11, DB12, Clear

Topic List	Page List: 1
Topic	"CTRL + :" in excel is amazing
Sahuagin 09/25/21 10:41:05 PM #12:	IIRC it's like Ctrl-: for date and Ctrl-Shift-: for time (or something) a way more useful one is Alt-= which will generate a sum formula for the selected range automatically, either below the selected range or to the right, depending where the selection is (you can generate column totals, row totals, and a grand total all at once if you select one more row and column than the range of values) --- *The truth basks in scrutiny.* https://imgur.com/GMouTGs http://projecteuler.net/profile/Sahuagin.png <cite>Sahuagin posted [p:958417913] in "CTRL... [t:79667318]...</cite> <quote>IIRC it's like Ctrl-: for date and Ctrl-Shift-: for time (or something) a way more useful one is Alt-= which will generate a sum formula for the selected range automatically, either below the selected range or to the right, depending where the selection is (you can generate column totals, row totals, and a grand total all at once if you select one more row and column than the range of values) --- The truth basks in scrutiny. https://imgur.com/GMouTGs http://projecteuler.net/profile/Sahuagin.png</quote> ... Copied to Clipboard!
Topic List	Page List: 1