Xcel

I like to learn more about Excel. The more I know the faster and error-free my work gets. It's a fun hobby.

[Xcel @Xcelie9]

How to force Microsoft Excel to show leading zeroes: https://t.co/XaWs0dr6qd @MichaelCrider

[Tom Urtis @TomUrtis]

Inserting a space before the nth last character in a string #MSExcel #BigData #DataScience #businessintelligence #Analytics

[Tom Urtis @TomUrtis]

Automating a comment that logs changes to your worksheet #MicrosoftExcel #Excel #BigData #businessintelligence

[Xcel @Xcelie9]

@TomUrtis Thank you very much Tom. Your tips are of great help.

[Tom Urtis @TomUrtis]

Tom's Tips For Excel #tomstips4excel #spreadsheets #excel #office365 #datascience

[Tom Urtis @TomUrtis]

Tom's Tips For Excel #Tomstips4excel #DataScience #Excel #Office365 #dataviz #dataanalysis #msoffice #spreadsheet

[Xcel @Xcelie9]

@TomUrtis Works for a number or a text (as criteria in cell B1). Thanks Tom.

[Xcel @Xcelie9]

@TomUrtis Thanks for this great and simple trick. I used to go to Column Width command on the ribbon.

[Xcel @Xcelie9]

@TomUrtis nice tip, never used that five Ms.

[Xcel @Xcelie9]

Great work Sumit! Nice worksheet and video. Thanks for sharing.
#excel #exceltips https://t.co/G5qcIPkYC8

[Sumit Bansal 📊📈 @TrumpExcel]

Count Cells Based on Background Color in Excel
https://t.co/DGuxOkEcM6
#Excel #ExcelTips

[Xcel @Xcelie9]

I started using worksheets in the early nineties:
Lotus-123
Symphony
Excel-97
Excel-2003 (kept for a long time)
(Skipped 2010)
Excel-2013

[Xcel @Xcelie9]

Just so people I follow know.

[Xcel @Xcelie9]

#excel
I sometimes temporarily "favorite" a tweet (to check it out later), then after I do (the checking) I "unfavorite" it ==>

[Tom Urtis @TomUrtis]

Tom's Tips For Excel: For sheet footer to display exactly eg This & That (notice ampersand), in Page Setup dialog enter This && That

[Xcel @Xcelie9]

#exceltips #excel #ShortCuts
The fastest way to delete a bunch of charts:
Ctrl+G,
Alt+S,
B,
Enter.

[Xcel @Xcelie9]

I remember by: a space bar resembles a lying column. (Hehehe)

[Xcel @Xcelie9]

#exceltips #excel #ShortCuts

To hide a:
Column: Ctrl+0
Row: Ctrl+9
I remember by shape resemblance: Column C, resembles 0,
R, resembles 9.

[Xcel @Xcelie9]

#exceltips #excel #ShortCuts
To insert a column/ row quickly:
Alt+I+C
Alt+I+R.
To delete:
Ctrl+Spacebar then Ctrl+- (minus)
row: use Shift

[Tom Urtis @TomUrtis]

.@Xcelie9 For that OK but Ctrl+D acts on selctd cells/Ctrl+' on activ cell. A1:A5=1-5. SelectA6:A1(A6 activ) Ctrl+D A1:A6=1 but Ctrl+' A6=5

[Xcel @Xcelie9]

@TomUrtis I see the difference now. Thanks!