ExcelBytes

ExcelBytes Hi friends, Welcome to my page Hi canmen/women,

I have been thinking quite a while to impart tips on Excel to one and all. Together we can……….

Having worked in the bank for almost 13 odd years, I have come across various users with different levels of knowledge in Excel. In my opinion I feel many of our colleagues need some helping hand in Excel. I assure you that it is no big deal to start and learn Excel. Once you start referring to my posts, you will really start loving Excel. And I am sure, you will be able to handle certain official

tasks very easily in Excel. So, this page is dedicated to all those canmen/women who are interested to know more about Excel. Come on guys, lets get going……… I heartily welcome all the canmen/women to this page where we will be discussing some really useful tips in Excel.

Creating drop-down lists from a range of cells.Have a column of relevant information as indicated in the picture.Now, yo...
09/04/2012

Creating drop-down lists from a range of cells.

Have a column of relevant information as indicated in the picture.
Now, you can create a drop down list from this information on another cell.

Follow these steps;

1. Prepare a list of Months & year
2. Select a cell outside the range of months.
3. Click Data Menu
4. Click Data Validation
5. Click Data Validation....
6. Settings dialog appears. Select List under Allow :
7. Click under Source and select the range of months from Apr to March.
8. Click OK.
9. The selected cell has the drop-down list. Click the pull down button, you will see the list of months.

04/03/2012

Repating rows on all pages.

1. On the ribbon, click the Page layout tab.
2.Click Print Titles. The sheet tab of Page setup dialog box appears.
3. Click Rows to repeat at top option.
4. Now, click the row headers in the sheet which you want to repeat. Excel fills the address of the rows in the text box.
5. If you want more than one row, then select the required number of rows. But, be sure about the rows to repeat on the pages.
6. Click Ok. Thatz it.
7. Choose the print preview [Ctrl, f, w, v] option to verify that your rows are repeating.

01/03/2012

Some Function key shortcuts

Place the cursor on one of the cells in a Excel sheet and try these shortcuts.

Ctrl ; - Insert's today's date Ctrl : - Insert's current time
Ctrl d - Fills down Ctrl r - Fills right
Shft Spacebar = Select row Ctrl Spacebar = Select column
Ctrl 1 - Show Format Cells... dialog box

Try these.

01/03/2012

Did anybody try creating custom lists in Excel. give your feedback

12/02/2012

Friends, Have you ever used custom lists in Excel. Just imagine a data which you require in a particular order. Say the names of Circles Agra.......Vizag. Everytime I want this list to be filled automatically by Excel without any hassle. Custom Lists will do this for you.

Click the Microsoft button at the top left corner of Excel window,
Click Excel options.
Popular -> Top options for working with Excel -> Edit Custom Lists...
Custom Lists dialog appears.
With the NEW LIST highlighted, under the List entries, start typing all the Circle names in alphabetical order one below the other using enter key after each circle. Click Add.
Nest List is added
Click Ok to come out to the option.
Once, you are in the excel sheet, type Agra in the first cell.
Copy the cells by dragging the indicator at the bottom right of the cell.
Excel fills all the circle names automatically.
Instead double clicking the indicator, also fills the entire list in the sheet.

Start experimenting... Send your comments/feedback.

12/02/2012

One of the significant enhancements in Excel 2007 is that the number of rows have been increased. Now excel sheets can hold over one lake rows. Earlier in XP ver it was only 65543 rows. Even the number of of columns have been increased. Check out.

For commands like New, Open, Save, Save As, Click the Microsoft button on the top left corner of the Microsoft Excel win...
31/01/2012

For commands like New, Open, Save, Save As, Click the Microsoft button on the top left corner of the Microsoft Excel window. Do venture into the same. You will find many old options there.

In Excel 2007, the erstwhile Menu/toolbars have been replaced with what is called the Ribbon. Ribbon is a graphical stre...
31/01/2012

In Excel 2007, the erstwhile Menu/toolbars have been replaced with what is called the Ribbon. Ribbon is a graphical stretch which will hold all the commands grouped together under different contextual heads so that all the relevant commands come at one place. It is very handly. The problem is that the options in the older versions have been regrouped in the new menu structure and it may take some time to trace them. You can scroll through various ribbon options by using your scroll mouse.

28/01/2012

Hi canmen/women,

Since, I presume that we have Excel 2007 installed in all the PCs in our Bank, I am thinking of introducing you all to one thing a day about Excel 2007. Though lot of changes have taken place in Excel 2007, many of the user friendly options/shortcuts have been retained in Excel 2007. You will be getting to know these things in the days to come. I will try to post as often as possible. Kindly spread the message to all Canmen/women.

First and foremost, the file formats in Excel 2007:

One needs to understand that with Excel 2007 the file format is changed to *.xlsx. Files created out of Excel 2007 will not be readable in older versions of Excel viz., 97, 2000, XP, 2003. But, all the files created out of earlier versions will be editable in Excel 2007. But, the features compatible with the older verions only will be available to such files. The new features, changes made in Excel 2007 will be learnt in the days to come.

Pls comment - Sridhar.

25/01/2012

HI Friends,

You quest to learn new ideas in Excel ends here. I am planning to post tips on Excel on this page. I will be glad to share my knowledge to all of you, since, I have found that even certain basic routine options in Excel are still unaccessed by the users. This is just a beginning, join me in spreading this light of knowledge to one and all.

Thanking you in anticipation,

Sridhar Ganeshan

Address

Bangalore

Website

Alerts

Be the first to know and let us send you an email when ExcelBytes posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Shortcuts

Share

Category