Repeat 1 to 10 in excel column

Sometimes, we may need to repeat a set of values in excel. Manually typing will take more time. Inorder to ease the process, you can follow any one of the following steps.

First type 1 to 10 in each column.

Now in the eleventh column, use the formula where the eleventh cell is equal to first cell.

Now drag it until you need the set of numbers to be repeated.

Tha another classic way of repeating a set of values is, first set you have to manually. Then copy the sets and paste it to get next set. Now copy both sets to get 3 and 4 th set.Now copy 4 sets to get 8 , followed by 16,32,64,128..

Even though it looks time consuming, believe me, it will not take more than 5 minutes,since it copies exponentially.

Excel Tricks: Convert Lowercase to Uppercase in MS Excel with Shortcut

Convert Lowercase to Uppercase in MS Excel

It is not possible to directly convert upper case to lower case letters and lowercase to upper case letter in Excel itself .

It may be possible with help of some macros. But for time being we can follow a shortcut procedure to accomplish the task.


Follow the below procedure to convert lowercase to upper case and vice-versa in MS excel.


1.Copy the row or column of text which you need to convert Small to capital letters or Vice-versa.

2.Now open MS word or MS outlook (HTML view)

3.Paste the data that you copied in MS excel

4.Select All the data by pressing Ctrl+A



5.Now press Shift+F3 , If only first letter is changed to different case, again press Shift+F3 one more time.

6.Now all the selected data will be converted into alternate case.

7.Now select all the data (Ctrl+A) and copy it.

8.Go back to excel, select the first row or column where the data should be entered and Paste the data (Ctrl+V)

9.You can choose Paste with source formatting and formula to get back the same settings as it was initially being set.

Excel : Not able to Pick Objects, Chart in MS Excel

Difficulty Faced:

While working in Excel workbook, Sometimes we cannot pick any objects like charts, Pictures, Autoshapes etc

Troubleshooting Method :

Method 1 : 

• Go to Find and Pick Select Objects option. Now go and try to pick the objects you want to select.
• If still you are not able to select the objects like auto-shapes, charts and other picture objects try method 2.

Method 2:

• Check whether your Excel workbook is in shared status. If it is in shared status, near the file name of , it will be displayed as shared with square brackets as shown below.

• Now Go to Review - Share work book - Uncheck the sharing option - save the workbook.
• Then try to select the objects .

Caution: Ensure no body is using this file while you are removing the sharing status. If anybody is using this file at the same time, request him to save and close the file to proceed with method 2.

Tips :

• If you want to select more than one objects at a time, Press ctrl key and select the desired objects.
• If you want to deselect specific objects, you can click the same selected objects once again to deselect it.

MS Excel : TroubleShoot: Not able to merge cells in Excel

This article helps you to merge cells in Excel by troubleshooting the Error.

While working in excel file, if the Merge and centre option is disabled or if the software shows error like cannot merge the selected cells, then we have to troubleshoot using the following technique.

Error: Not able to merge cells in a shared workbook

Cause : Your Excel workbook may be in Shared status.

Reason: If someone merged the cells in a Excel file which is in shared status, then it may result in conflict if two or more people work on the same cells at a time. So, Smart minds of Microsoft decided to disable this Merge and center option while the Excel Workbook is shared status.



Troubleshoot :

• First Ensure no body is currently opened and working in this Excel WorkSheet . 
• You can check this by clicking Review - Share Workbook. 
• The window opened now should show only your name in the list. If anybody opened that excel workbook, ask him to save and close the file.
• Now Uncheck the option Allow changes by more than one user at the same time and Press Click OK
• Now a pop up will be shown that file will be automatically saved. Press OK.

We are done. Now you will be able to merge the cells .

Once you are done with the merging the cells process, save the file and again go to Review - Share workbook. So that , other people can work on the file at the same time you are working here.