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"
Tired of copy and paste? Why not automate! Contact us for a free quote, no macro too small. #exceltips #vba #copyandpaste #microsoft #excel
1
3
#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.
Replying to @MicrosoftPH
“@MicrosoftPH: This #ExcelTip should help you do your finance & accounting matters in minutes! teapawt.net/MicrosoftPH/status/561…” #excel SUM all above
1
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
#Excel shortcut time hit Ctrl + Y to repeat a cell's contents! #spreadsheet #microsoftexcel
#excel #exceltip #excelshortcut Morning! Time for today's tip! Hit Ctrl + U when a cell is highlighted this will underline the text #done
TopExcelTips retweeted
Sort your Excel data on one column or multiple columns. In ascending or descending order. excel-easy.com/data-analysis…
3
6