KING OF EXCEL: Atlas Excel

Showing posts with label Atlas Excel. Show all posts

Thursday, January 30, 2020

Linking a Drawing Object to a Cell

KingExcel.info January 30, 2020

Linking a Drawing Object to a Cell Here’s how you can link a cell’s value to be displayed inside a drawing object. In this example, a Tex...

Tuesday, January 28, 2020

Atlas Excel

"Did You Know…”

KingExcel.info January 28, 2020

"Did You Know…” Did you know : You can insert a new worksheet by pressing Shift+F11 . Immediately thereafter, to continue inserting...

Monday, January 27, 2020

Atlas Excel

Forcing Data Entry to Include a Specified Character

KingExcel.info January 27, 2020

Forcing Data Entry to Include a Specified Character Data Validation is an excellent way to control data entry to meet a certain condition...

Sunday, January 26, 2020

Atlas Excel

Entering an Ampersand in Your Header or Footer

KingExcel.info January 26, 2020

Entering an Ampersand in Your Header or Footer If you’ve ever wondered why a custom header or footer does not show an ampersand ( & )...

Friday, January 24, 2020

Atlas Excel

Formatting Large Numbers as Decimalized Gigabytes

KingExcel.info January 24, 2020

Formatting Large Numbers as Decimalized Gigabytes When you work with numbers so large that Excel puts them in Scientific Notation format,...

Atlas Excel

Calculating Dates for Last Day of Current, Previous, and Future Months

KingExcel.info January 24, 2020

Calculating Dates for Last Day of Current, Previous, and Future Months As pictured below, here are formulas that return the date for the ...

Thursday, January 23, 2020

Atlas Excel

Finding the First and Last Days of the Week and Month

KingExcel.info January 23, 2020

Finding the First and Last Days of the Week and Month Here are formulas to return various dates of first and last days of a given month. ...

Atlas Excel

Converting an Elapsed Time to a Decimal Number

KingExcel.info January 23, 2020

Converting an Elapsed Time to a Decimal Number Some employers pay their employees based on work time that is measured in decimals as port...

Wednesday, January 22, 2020

Atlas Excel

Entering a Function’s Arguments Tooltip in a Cell

KingExcel.info January 22, 2020

Entering a Function’s Arguments Tooltip in a Cell You can press Ctrl+Shift+A in mid-entry of your worksheet functions to show their too...

Monday, January 20, 2020

Atlas Excel

Copying Formulas While Keeping Their Relative and Absolute References

KingExcel.info January 20, 2020

Copying Formulas While Keeping Their Relative and Absolute References Here’s how you can copy a set of formulas and paste them elsewhere,...

Atlas Excel

Reverse Lookup of nth Highest and nth Lowest Numbers

KingExcel.info January 20, 2020

Reverse Lookup of nth Highest and nth Lowest Numbers Here are several examples rolled into one screen shot that show how to: • Return the...

Atlas Excel

Doing a Lookup for Last Number or Last Text in a List

KingExcel.info January 20, 2020

Doing a Lookup for Last Number or Last Text in a List Here is how you can look up items in one column, based on the last cell in a differ...

Atlas Excel

Going To the Precedent Cell with a Keyboard Shortcut

KingExcel.info January 20, 2020

Going To the Precedent Cell with a Keyboard Shortcut Here’s a cool tip for the keyboard shortcut Ctrl+[ which takes you from the formul...

Sunday, January 19, 2020

Atlas Excel

Showing Your Column Headers as Letters or Numbers

KingExcel.info January 19, 2020

Showing Your Column Headers as Letters or Numbers You can show your column headers as letters or numbers. Here’s how to change column he...

Atlas Excel

Conditional Formatting examples for repeated items in a list.

KingExcel.info January 19, 2020

Conditional Formatting examples for repeated items in a list. The Conditional formatting rule for unique entries in range A3:A14 is =CO...

Wednesday, January 15, 2020

Atlas Excel

Pasting a Formulas Static Value in Cell Below

KingExcel.info January 15, 2020

Pasting a Formulas Static Value in Cell Below You probably know that if you select a cell below a cell that contains a value or formula, ...

Crafted with by TemplatesYard

Pages

Thursday, January 30, 2020

Tuesday, January 28, 2020

Monday, January 27, 2020

Sunday, January 26, 2020

Friday, January 24, 2020

Thursday, January 23, 2020

Wednesday, January 22, 2020

Monday, January 20, 2020

Sunday, January 19, 2020

Wednesday, January 15, 2020

Popular Posts

Popular Posts

Popular Posts

Socialize

Popular Posts

Total Pageviews

Search This Blog

Translate

Now

Public

Comments

Popular Posts

Kết nối với chúng tôi

Bài đăng phổ biến

Popular Posts

About me

Contact Form

Pages