Format in Excel 2013 2010 2007 2003

Protecting workbook elements

Protecting a workbook is different from protecting the Excel file with a password to prevent reading/writing or locking the spreadsheet elements to prevent editing. Workbook protection forbids other users to add, move, rename or delete worksheets and defends against viewing hidden worksheets or hiding worksheets.

How to create a dependent drop-down list

The drop-down list is a handy feature provided by Excel data validation tools. Drop-down menus limit the possible choices and help to avoid mistakes. However, not so many Excel users know the Source field of the Data Validation dialog is a formula field. Formulas in the Source field should return the list of the values, but they are not necessarily a range or a list of options.

How to create a computable drop-down list

Dynamic, dependable, conditional, or calculated drop-down list in Excel implies that the contents of the drop-down list for the current cell should depend on values in the other cell and change dynamically when the value of the controlling cell changes.

Creating a Drop-Down List in a Cell

Manual data entry into spreadsheets and especially entering data into text cells leads to many errors. Excel data validation tools allow you to reduce the inaccuracy of Excel data entry by restricting the set of possible values to a pre-defined list. Users can select the item from a drop-down list with few choices, instead of typing text into the data entry form template.

Change the decimal point to a comma or vice versa

When you import data into Excel spreadsheets from Internet pages or CSV files, Excel fails to recognize some numbers and converts them to the default text type. Temporarily changing Excel settings helps to reduce the amount of manual work and the number of errors on replacing comma to point, dot to comma, semicolon to comma, etc. Also, you need to change decimal delimiter settings for printing or exporting data for international users.

How to hide the cell values in Excel without hiding cells

Conditional formatting of Excel cells simplifies highlighting values by adding color scales, data bars, spark lines and in-cell icons to the cell. The exact values of the highlighted cells rarely meaningful and may even interfere with the perception of information. Custom cell format allows hiding values of such cells without hiding the cells.

How to change comma to decimal point and vice versa in Excel

Because of different standards of different countries and cultures, there is a lot of situations when you need to change commas to dots, decimal points or dots, decimal points to commas in an Excel spreadsheet:

How to view current stocks prices and other quotes in Excel

There are countless reasons why you might need to have stock prices in your Excel spreadsheet. In the past, you had to copy and paste from Yahoo Finance or another financial service, but at the moment, Microsoft offers a new way to add and update some stock information such as stock prices, changes of price, etc.

How to create an automatically extended or dynamic drop-down list

When you work with data in Excel, often you need to add more and more of new data. However, it takes some time to update formulas, charts, tables, when you add new data. Excel proposes functions that can help to customize your data and avoid routine updating. This tip is about creating an automatically extended (also known as dynamically updated or just dynamic) drop-down lists.

How to copy computed subtotals in Excel

When you compute subtotals in your spreadsheet, it can be necessary to select only subtotals and copy them to another sheet for future processing. If you select subtotals and copy them using copy-paste (Ctrl+C and Ctrl+V), Excel paste all source data with subtotals. This tip demonstrates the workaround that allows you copy just rows with subtotals.