LyteByte

You are browsing the archives of Excel.

Insert header and footer in Excel from Office 2007. Custom design header and footer with left, center and right sections. Add Page numbers, Number of pages, Current Date, Current Time, File Path, File Name, Sheet name and picture. Add different header and footer in first page of the Excel sheet, Different for odd and even pages

How to unhide personal.xlsb personal macro workbook in Excel 2007 in vista and XP. Edit personal macros in VB editor. unhide hidden workbook in excel

Use Chart Advisor from Microsoft Office Labs in Excel 2007 to present the data with the best chart and also use the features like Filter data and Modify chart to present data in bar chart, cluster chart, line chart, area chart, scatter plot etc.

Enter multiple lines in single Excel cell or manually insert word wrap in excel cells so that it allows to enter more than one line in a single Excel cell. Keyboard Shortcut to word wrap in Excel cell.

Get live data from web in Excel 2007 through the advanced features of Excel 2007 web data add-in. Tutorial on how to import live data to Excel sheet with automatic refreshing.

Change text direction or orientation in excel cells. Format cell alignment and the text orientation to Angle Counterclockwise (45 degrees), Angle Clockwise (45 degrees), Vertical Text, Rotate Text Up, and Rotate Text Down in Excel 2007 and Excel 2003

Get live data from web, online in excel 2007 and create charts and do calculations with formula. Live data of stocks and portfolios from the business sector and do calculations in Excel to get quick result. Data are automatically updated from the internet and also the calculations and the chart.