TopExcelTips (@TopExcelTips) profile picture

All the Excel Help you need! From Copy and Paste to VBA no question to big or small!

London
Joined February 2013
TopExcelTips retweeted
Send Emails From Excel - #excel excelzoom.com/send-emails-fr…
5
3
Hello Everyone, If you want to know how to filter the data based on the selection of cell using VBA in Microsoft... fb.me/1BGXb6csO
"@fkeys #ExcelTip #Excel2013 ""CTRL+0"" Hides the selected Columns. #KentCourses #ExcelTraining by registered MCT's"
2
1
"@fkeys #ExcelTip #Excel2013 ""CTRL+W"" Closes the Selected Workbook window. #KentCourses #ExcelTraining by registered MCT's"
4
2
"@fkeys #ExcelTip #Excel2013 Function Key ""F5"" Displays the GoTo dialog box. #KentCourses #ExcelTraining by registered MCT's"
#ExcelTip Ctrl+4 (like Ctrl+U) Applies or removes underlining. #Excel
#ExcelTip Ctrl+6 Alternates between hiding and displaying objects. #Excel
#ExcelTip CTRL+E is not assigned as a shortcut. So, it makes a great shortcut key for your macros -- CTRL+SHIFT+E.
Sometimes an #Excel field isn’t set correctly i.e. ‘number’. Multiply the cell by one and it’ll convert to *1. #Exceltip
#ExcelTip CTRL+C Copies the selected cells.
1
1
#ExcelTip CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
TopExcelTips retweeted
Tom's Tips For Excel: Data Validation custom formula to disallow a certain character, example a space. =LEN(A1)=LEN(SUBSTITUTE(A1," ",""))
3
2
TopExcelTips retweeted
Send Emails From Excel - #excel excelzoom.com/send-emails-fr…
4
1
TopExcelTips retweeted
Sort your Excel data on one column or multiple columns. In ascending or descending order. excel-easy.com/data-analysis…
3
6
TopExcelTips retweeted
#Excel Tip. F2 allows you to edit a cell. To find more register for a webinar: aka.ms/Fp3b8i
If you want to know how to get the name of the sheet in a cell in Excel 2010 / 2013, check below link.............. fb.me/73abI0ePK
1
1
2
Great #Excel tip! Type equal sign = & the Name Box lists recently used functions. Select one & its function help appears via @TomUrtis
Tip: It takes about 1/2 the time to learn Excel or Word when using private training instead of public classes.
If you want to know how to specify a tab character in VBA , check below link.............. fb.me/2na2M2Kh9
1
1