Microsoft Excel
360 Stories
Use VBA to find hidden Excel sheets
Techguide If you have hidden sheets in Excel, it might be helpful to programmatically manipulate those sheets.
Tags: Microsoft Office, Document, File, Backup, File System, ASCII, Microsoft VBA, Microsoft Excel, Microsoft Windows, Microsoft Access
Microsoft Access 2010 new feature overview
Techguide Here are some of the new features you can expect to see in Access 2010, including a Web-ready format and an improved macro environment.
Tags: Microsoft Office, Microsoft Office, Row, Database, Cell, Field, Microsoft Corp., Data Type Gallery, Access 2010, Office Theme
Quickly delete every nth row in Excel
Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column, MsgBox, Microsoft Corp., OrderID, Microsoft Word Override Word, Goto, Clear, Microsoft Excel
Use Access Office Links tool to convert a report to an Excel worksheet
Techguide Here's a quick and easy trick for getting your Access report data into Excel--organized just the way you want.
Tags: Microsoft Office, Option, Tool, check box, shortcut menu, Microsoft Excel, Microsoft Word 2007, Microsoft Access, Microsoft Office, Microsoft Word
Using Microsoft Excel with SharePoint 2007
Techguide Excel and SharePoint 2007 offer interactive features that simplify many collaborative tasks. Here's a look at what's in store.
Tags: Microsoft Office, Microsoft Corp., Data, Table, List, Workspace, SharePoint List, Datasheet, Refresh, Microsoft Excel
Use Wingdings to add graphics to Access forms and reports
Techguide You can insert a symbol or picture into a form or report, but embedded graphics consume a lot of resources.
Tags: Microsoft Office, Error, Microsoft Corp., Code, MsgBox, keyboard shortcut, Graphics, vbOKOnly, Alan Wood, Insert
Microsoft fixes 26 flaws with 11 patches
News Updates, six of which are critical, affect Microsoft Office suite and individual applications as well as Internet Explorer.
Tags: Security, Network security, Office suites, Microsoft Office, Microsoft Corp., Vulnerability, Bulletin, Flaw, Execution, Attacker
Microsoft fixes 20 flaws with 11 patches
News The security bulletins, four deemed critical, affect Windows, Internet Explorer, Microsoft Office, and Microsoft Host Integration Server.
Tags: Security, Microsoft Windows, Microsoft Office, Microsoft Corp., Vulnerability, Microsoft Host Integration Server, Bulletin, Flaw, Update, Attacker
Zap unwanted formatting in Word
Techguide You can spend a lot of time formatting content in a Word document and then even more time trying to get rid of it!
Tags: Microsoft Office, Microsoft Office, Customization Tool, Microsoft Excel Microsoft Excel 2010, Excel 2010, October Sale, C, Microsoft Corp., Sales, Microsoft Excel 2007
Print gridlines and headings in Excel
Techguide A printout of data can be more useful if you print gridlines and column and row headings. The gridlines help keep you on track.
Tags: Microsoft Office, Microsoft Corp., Microsoft Excel 2007, page layout, Microsoft PowerPoint, printing, Microsoft Excel, spreadsheet, Microsoft Office
Use a nonbreaking space to keep words together
Techguide Learn how to keep two words together when they happen to fall at the end of the line and Word pushes the last name to the next line.
Tags: Microsoft Office, Microsoft Corp., Backup, Item, Tools Menu, e-mail, keyboard, Microsoft Excel, Earth, built-In
Nudge paragraphs in a Word document
Techguide Sometimes you need just a little more space before a paragraph. You have to update the style to reflect a little more space before or after each paragraph.
Tags: Microsoft Office, Formula, Microsoft Corp., user-defined function, Cell, Microsoft VBA, Ingersoll-Rand, performance, keyboard, Microsoft Excel
Compress pictures to reduce the size of your PowerPoint presentation
Techguide While pictures improve the Powerpoint presentation's appeal, they increase the file's size.
Tags: Microsoft Office, Name, Presentation, PowerPoint 2007, Microsoft Corp., software, Cell, File, Tool, Mouse
Display hidden data in an Excel chart
Techguide By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won't display that data in a chart.
Tags: Microsoft Office, Database, Option, Chart, Microsoft Corp., Tools Menu, Figure B, Microsoft Excel, Microsoft Word, technique
How to display pictures that appear to be partially hidden
Techguide Sometimes, an in-line text picture doesn't display completely--you can see just the bottom of the image. Find out what you can do to correct the problem.
Tags: Microsoft Office, Slide, Cell, Training, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft Office 2007, Microsoft Excel, Microsoft Office, Microsoft Word
