Excel: Convert column to hyperlink

========= QUESTION ——— I have a spreadsheet full of web and/or email hyperlinks, but some do not show as hyperlinks. How do I convert them?   ========= ANSWER ——— =HYPERLINK("mailto:"&A1, A1) =Hyperlink(A1)   ========= EXAMPLES ———   ========= APPLIES TO / KEY WORDS ——— Hyperlink Auto Create Hyperlink   ========= REF ——— — http://anySiteSupport.com http://anySiteHosting.com

By | 2015-07-06T16:23:21+00:00 July 6th, 2015|Computers, Excel, Microsoft|0 Comments

What does E-02 mean in a decimal number?

========= QUESTION --------- When I run a query in Access, or have large number in Excel, what does it mean when it is a large number with an E-02, or E+02 at the end? Or for that matter, E+/-any number?   ========= ANSWER --------- This is Exponential Notation (also known as Scientific Notation or Standard [...]

By | 2017-12-01T23:47:38+00:00 August 12th, 2011|Access, Computers, Documentation, Excel, Math, Microsoft|1 Comment

Microsoft Excel: Transpose Columns and Rows

=========QUESTION---------You have a spreadsheet where you want the data you have entered as rows to now be in columns and the data you have entered as columns to now be in rows. =========ANSWER---------Select your data, copy.Select where you would like to paste the newly transposed dataSelect the the dropdown arrow under Paste in the toolbar, [...]

By | 2011-04-06T14:54:50+00:00 April 6th, 2011|Computers, Documentation, Excel, Microsoft|0 Comments

Keyboard shortcuts for Microsoft Excel

=========QUESTION / DESCRIPTION---------Keyboard shortcuts for Microsoft Excel =========EXAMPLES---------F2Puts the current cell into edit mode, just as if you clicked the Formula Bar ---------. =========REFERENCE---------http://www.mvps.org/dmcritchie/excel/shortx2k.htm =========APPLIES TO / KEYWORDS---------Microsoft Excel ---http://www.anysitesupport.com/keyboard-shortcuts-for-microsoft-excel/

By | 2011-04-05T09:56:54+00:00 April 5th, 2011|Computers, Documentation, Excel, Microsoft|0 Comments