Category: How-to's

Count Words in a Cell - "5"

Formulas, How-to's

Hi there,

  Share on Facebook




Sometimes we get a requirement to count the number of words in a cell. This is not a difficult task, a simple logic works to get this done.

 

RERUIREMENTS:

  • LEN
     
  • TRIM
     
  • IF
     
  • SUBSTITUTE

  

Full story »

OverCome PageBreaks after Print Preview

excel_usage, How-to's, Excel Tips

Hi there,

 Share on Facebook

 

 

 

Do you know how to get rid of page breaks after print preview option get deselected. This will actually pinch the excel user to see me (forcefully). To avoid such page breaks we have two options.

 

Option 1: Using Excel Options

Full story »

Insert / Delete Worksheets

excel_usage, How-to's, Excel Tips

Hi Folks,

Share on Facebook



Firstly, Happy Navarathri Festival (day 1) to you and your family. Today let's see how to Insert or Delete worksheets using options as well as keyboard shortcuts. 

 

INSERT WORKSHEET(S):

In HOME tab --> Goto Cells Group --> Click on INSERT --> choose last option INSERT SHEET


 

or

Full story »

Navigate Excel Sheets

How-to's, Excel Tips

Hi there,

 Share on Facebook

 


 

After a long gap, around 20 days, again I am back to share some interesting Excel tips which helps to your reporting needs. There are many reasons for why I have not attended to add new posts. Few reasons to make you understand are Addressing the Formulas Crash Course Doubts, Preparing/Adding New Videos, Relocated from Bangalore to Gudibanda, Birthday Bash, United AndhraPradesh Protests since 50+ days, Getting new Internet connection, Setting up the space for my system to start my new life (for next six months) in my native with parents and many took me these many days.

Full story »

List FileNames in a Folder (no VBA)

Formulas, How-to's, Learn Excel

Hi there,



FLASHBACK:

We have seen how to count worksheets in a workbook, which requires a special attention on the formula because this formula is not an ordinary formula or plain formula where we can use in a normal method to get results (normal method indicates typing a formula or function in a cell starting with = and bla bla bla....). This is a special case where XLM macro function should be used to generate the results. To remember, XLM function will work only for "named ranges"

 

NEW CHALLENGE:

Today, we have a different challenge in front of us, "How to find the list of file names in a folder?" You might think, is this fellow (admin) speaking about all the files in the folder or only Excel files in the folder, right?.

 

Yes, I am speaking about all the files with all the extensions in a folder can be listed by using Excel function. Some example extensions which we can list are:

Full story »

Count Worksheets in a Workbook (no VBA)

Formulas, How-to's, Learn Excel

Hi there,

  Share on Facebook

 

 

For your information, from today, I will maintain font as "Verdana"

FLASHBACK:

When I was a kid, I remember my dad was asking me to tell about numbers (1,2,3, ...100). I believe I was around 4 (four). I remember this because it applies to all the kids.

That was the time my dad used to scare me to tell the alphabets, words, numbers, and roman numbers. I was good in other things but coming to numbers I am really sick since that time. Thank god, I am still scared of numbers till today ;) (of-course, not for counting money :) ).

When I was telling numbers to my dad, I will start with number one and will definitely end with still one only ;). I don't know how many kids will do this but I was really doing this. Anyhow later on my Dad forced me to take mathematics as my optional subject in my pre-degree and degree.

Because, my dad's philosophy was achieving results in challenging subjects will give more satisfaction. Of-course it is true but doing it in practice is really awke. ;)


TOPIC FOR TODAY: 

Ok, we will move on to the interesting topic now. To count the number of sheets in a workbook, open the workbook and see the bottom of the workbook to find the number of sheets like "Sheet1", "Sheet2", "Sheet3" etc., depends on the number of sheets opened by the user (default set by Microsoft is 3). 

 

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Skin Faktory.