}

Blog

Need Quick Excel Help? Have a question that needs to be answered? Looking for a quick VBA code/book/  add in/or template?

Send us the quick text and we can help

javascript open excel

Ok, Here is how you use Javascript to open Excel.

Try the following code and get it going.

======

amortization formula excel

If you are looking for amortization formula excel may be the best th

excel amortization table

OK, here is the Free to download Excel Amortization Template. You may use this to get your monthly outpayments against a loan that you may have taken.

double elimination excel

 

Ok, Here is the code which will have you in double elimination in excel.

Break Excel VBA Password

1. Create a new simple excel file.

Create a drop-down list from a range of cells

To make data entry easier, or to limit entries to certain items that you define, you can create a drop-down list of valid entries that is compiled from cells elsewhere on the worksheet.

Image: 
untitled.bmp

All About hyperlinks

A hyperlink is a link from a document that opens another page or file when you click it.

Split names with Text to Columns

A well-designed spreadsheet will split first names and surnames into separate columns. This way, we are able to sort or filter by either of these.

Colour every second row

A report is easier to read if every second row is shaded. However, manually shading every second row would be tedious. Instead, follow these steps:

Move, delete or copy a toolbar button quickly

To customise our toolbars, we generally need to enter Customize mode. However, we can move or copy toolbar buttons without enabling Customize mode.


:
:

eXTReMe Tracker