Tag: Keyboard
-
Find and Replace carriage return in MS Excel
Scenario: Here is a scenario that I have come across recently in Excel. I have the data in column that is split across multiple lines in each cell, more technically speaking, separated by carriage returns. i.e., the text in the cell is separated by pressing ALT + ENTER. see the…
-
Microsoft Excel behaves strange when tried to replace or remove asterisk (*). Why..?
Here I came across a scenario of Microsoft Excel behaving strange, when trying to find and replace asterisk character (*) with another character. Scenario: Here is a list of data in an excel worksheet containing some fictitious data of names and salaries of a few employees. You can see that some of the…
-
MS Excel Keyboard Shortcuts
Hi.. Here I have composed a comprehensive listing of keyboard shortcuts for Microsoft Office Excel 2010 in downloadable PDF format. Please do share the keyboard shortcuts if you know any that are missing in this list and help improve this listing. Do share your comments or suggestions, if any.. [office…