KING OF EXCEL: Atlas Excel

Showing posts with label Atlas Excel. Show all posts

Monday, January 13, 2020

Copying Formulas While Keeping Their Relative and Absolute References

KingExcel.info January 13, 2020

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

Sunday, January 12, 2020

Atlas Excel

Selecting All Cells With Comments or Data Validation

KingExcel.info January 12, 2020

Selecting All Cells With Comments or Data Validation I previously posted this example of selecting only constants or formulas . You ca...

Thursday, January 9, 2020

Atlas Excel

Going To the Precedent Cell with a Keyboard Shortcut

KingExcel.info January 09, 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...

Atlas Excel

Using Data Validation to Force a Decimalized Numeric Entry

KingExcel.info January 09, 2020

Using Data Validation to Force a Decimalized Numeric Entry Data Validation is an excellent way to control data entry to meet a certain co...

Tuesday, January 7, 2020

Atlas Excel

Using Data Validation to Disallow Entry of Item in a List

KingExcel.info January 07, 2020

Using Data Validation to Disallow Entry of Item in a List Here’s an example of using Data Validation to NOT allow a particular data item ...

Monday, January 6, 2020

Atlas Excel

Zooming In and Out With Your Mouse Wheel

KingExcel.info January 06, 2020

Zooming In and Out With Your Mouse Wheel You can press the Ctrl key on your keyboard while turning your mouse wheel forward to zoom in,...

Sunday, January 5, 2020

Atlas Excel

Seeing Values and Formulas on the Same Spreadsheet at the Same Time

KingExcel.info January 05, 2020

Seeing Values and Formulas on the Same Spreadsheet at the Same Time Did you ever want to watch your spreadsheet in two separate windows i...

Friday, January 3, 2020

Atlas Excel

Using a Formula to Get Your Active Worksheet’s Name, and Active Workbook’s Path and Name

KingExcel.info January 03, 2020

Using a Formula to Get Your Active Worksheet’s Name, and Active Workbook’s Path and Name Here are two formulas, one to return the active ...

Tuesday, December 31, 2019

Atlas Excel

Finding the Relative Position of an Item in a List or Table

KingExcel.info December 31, 2019

Finding the Relative Position of an Item in a List or Table You’ll sometimes need to know the relative position, such as the relative r...

Monday, December 30, 2019

Atlas Excel

Toggling to Show or Hide Your Group and Outline Buttons

KingExcel.info December 30, 2019

Toggling to Show or Hide Your Group and Outline Buttons When you have a worksheet with rows and/or columns that have been grouped… …you...

Saturday, December 21, 2019

Atlas Excel

Rounding Numbers By Fractions or Decimals

KingExcel.info December 21, 2019

Rounding Numbers By Fractions or Decimals When rounding numbers to a particular decimal factor, you can express that rounding factor in your...

Friday, December 20, 2019

Atlas Excel

EVBA’s Tutorials For Excel: Adding and Subtracting Time in Hours Minutes and Seconds

KingExcel.info December 20, 2019

EVBA’s Tutorials For Excel: Adding and Subtracting Time in Hours Minutes and Seconds Formula examples for hours, minutes, and seconds being ...

Atlas Excel

Returning a Value From Every Nth Cell

KingExcel.info December 20, 2019

Returning a Value From Every Nth Cell Here’s a formula to help you list (that is, return) the values from every (in this case) 6 cells. This...

Thursday, December 19, 2019

Atlas Excel

Finding the Number Closest to Zero

KingExcel.info December 19, 2019

Finding the Number Closest to Zero Here are two formulas, one to tell you the number closest to zero in a list, and the other to tell you th...

Crafted with by TemplatesYard

Pages

Monday, January 13, 2020

Sunday, January 12, 2020

Thursday, January 9, 2020

Tuesday, January 7, 2020

Monday, January 6, 2020

Sunday, January 5, 2020

Friday, January 3, 2020

Tuesday, December 31, 2019

Monday, December 30, 2019

Saturday, December 21, 2019

Friday, December 20, 2019

Thursday, December 19, 2019

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