How to move your cursor around your worksheet quickly?

Trick To Quickly Move Around Your Worksheets, Quickly Move your cursor position by Double-Click. (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); There is a very quick, easy and useful trick in Microsoft Excel about which most of the excel users don't know. You can move your cursor postion around your MS Excel Worksheet by Double-Click. You can select your data by this trick too.This feature has...

Read More

Count Commas (,) in Excel Worksheet.

How to count comma or commas (,) in your Microsoft Excel Worksheet with Example. Find out the number of commas in excel cells. (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); At work, Sometimes we need to count the number of commas in a range of selected cells. However, there is no Excel Function to do this type of task, but here we will know a trick to find out the count of Commas (",") in...

Read More

Concatenate Dates with Text in MS Excel With Example.

Concatenate Dates with Text, How to Write Date with Text in Excel Worksheet Cell? Easiest way to concatenate dates with text with example in MS Excel (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); Last week my friend ask me how to concatenate Date with a String or Text, but that time I couldn't give him the solution because I was on Himachal Trip. So now here we will learn how to Concatenate...

Read More

View Two Excel Sheets Simultaneously / together

How to View Two Sheets of a Workbook Simultaneously / together in MS Excel.(adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); Sometimes we need to see more than one sheets of a Excel Workbook together / simultaneously, so if there is any requirement like this how can you do that in Microsoft Excel. Here is a very simple and easy way to do this.1-New WindowSo if you want to view more than one page...

Read More

PSTET 2014 Online Application Form / PSTET 2014 Jobs

PSTET 2014 Online Application Form at www.tetpunjab.com / Punjab State TET Notification.PSTET Jobs Application form.PSTET RecruitmentPSTET (Punjab State Teacher Eligiblity Test) 2014 –  Punjab State TET Update | PSTET Online Application Form / Apply for PSTET through online on PTSTET official website portal @ www.tetpunjab.com.The Department of School Education, Punjab state Government has published a Notification 2014. They are going to conduct...

Read More

Change Default Function COUNT to SUM in Pivot Table in Excel.

Excel Best Trick to Make SUM as Default Function in Pivot Table instead of COUNT, How to Make Pivot Table Default To SUM Not COUNT. (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); When Pivot Table is used in Excel by default it shows the COUNT of the values. But if you want to SUM the values in your data every time you use Pivot Table then how is it possible, what should we do to make Pivot Table...

Read More

Trick to make Excel Data fit to display

How to Make Your Spreadsheet Fit to the display, Fit Excel Spreadsheet to Screen. An easy trick to make your Excel data fit display / screen.(adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); Many times You put a lot of preparation into designing your spreadsheets the way exactly you want Excel spreadsheets, but you find that your Excel spreadsheet is little wider to fit your display or screen. Now...

Read More

Recover Your Unsaved Work in MS Excel Spreadsheet

Recover Unsaved Changes in MS Excel Spreadsheet / How To Recover A Excel Workbook You Forget To Save Changes To. (adsbygoogle = window.adsbygoogle || []).push({}); (adsbygoogle = window.adsbygoogle || []).push({}); Many times you have accidentally closed a Excel workbook without saving changes to it and after that immediately you realized your error. This may happen after you have been working on a new workbook or after you have made changes to...

Read More