CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Wed, 30 Jul 2025 22:51:56 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20110118093610 location: https://web.archive.org/web/20110118093610/https://answers.oreilly.com/tag/Excel server-timing: captures_list;dur=0.573583, exclusion.robots;dur=0.023687, exclusion.robots.policy;dur=0.012508, esindex;dur=0.015784, cdx.remote;dur=9.452796, LoadShardBlock;dur=299.978120, PetaboxLoader3.datanode;dur=133.084396, PetaboxLoader3.resolve;dur=82.570568 x-app-server: wwwb-app219 x-ts: 302 x-tr: 343 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: SERVER=wwwb-app219; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Wed, 30 Jul 2025 22:51:58 GMT content-type: text/html;charset=UTF-8 x-archive-orig-date: Tue, 18 Jan 2011 09:36:11 GMT x-archive-orig-server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP/5.2.8 x-archive-orig-x-powered-by: PHP/5.2.8 x-archive-orig-set-cookie: answers_session_id=deleted; expires=Mon, 18-Jan-2010 09:36:10 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-set-cookie: answers_session_id=deleted; expires=Mon, 18-Jan-2010 09:36:10 GMT; path=/; domain=.oreilly.com; httponly x-archive-orig-cache-control: ,no-cachemust-revalidate, max-age=0 x-archive-orig-expires: 0 x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Tue, 18 Jan 2011 09:36:10 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Thu, 15 Oct 2009 13:10:42 GMT", ; rel="prev memento"; datetime="Sat, 15 Jan 2011 00:44:27 GMT", ; rel="memento"; datetime="Tue, 18 Jan 2011 09:36:10 GMT", ; rel="next memento"; datetime="Wed, 16 Mar 2011 22:01:12 GMT", ; rel="last memento"; datetime="Sun, 03 Aug 2014 14:41:27 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: alexa-web-20110708223754-00038/52_19_20110118093547_crawl100.arc.gz server-timing: captures_list;dur=0.619849, exclusion.robots;dur=0.022883, exclusion.robots.policy;dur=0.011234, esindex;dur=0.011358, cdx.remote;dur=6.600300, LoadShardBlock;dur=119.199725, PetaboxLoader3.datanode;dur=83.555309, PetaboxLoader3.resolve;dur=1254.097685, load_resource;dur=1230.948383 x-app-server: wwwb-app219 x-ts: 200 x-tr: 1507 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip Excel Questions and Answers - O'Reilly Answers

Jump to content

O'Reilly Answers

Clever Hacks. Creative Ideas. Innovative Solutions.

Share your knowledge

Welcome

Help

O'Reilly Answers is a community site for sharing knowledge, asking questions, and providing answers that brings together our customers, authors, editors, conference speakers, and Foo (Friends of O'Reilly). More »

Send us feedback
Feed icon

O'Reilly Answers Feed
Twitter icon

@oreillyanswers

Topics: Excel

Excel Feed Excel Open Questions Feed Excel Email Open Questions via Email

What's New in Office 2011 for Macintosh

By ChrisGrover : 11 January 2011 - 03:12 AM
Microsoft gave Office 2011 significant improvements over its predecessor, Office 2008. You can’t miss the new ribbon and Spotlight search box—but there’s also an array of less obvious enhancemen...
Tags:
2Votes

1Comment
How to Export Customer Information from Quickbooks 2011

By BonnieB : 12 November 2010 - 04:40 PM
QuickBooks lets you do lots of cool things with customer info, but say you have a mail merge already set up in FileMaker Pro, or you want to transfer all of your customer records to Access to track pr...
Tags:
0Votes

0Comments
How to visualize an Azure table in Excel, using OData

By JonUdell : 21 September 2010 - 10:57 AM
Introduction The elmcity service makes extensive use of the Azure table service. Why use this cloud-based key/value store instead of the corresponding SQL-based offering, SQL Azure? The standard ...
Tags:
1Vote

0Comments
Is there a way to automate worksheet names in Excel?

Asked by SUPERNOVIA : 15 September 2010 - 12:39 PM

Answered by Alanle [MS} : Sep 17 2010 07:17 AM
Hi, There is, the article that describes how to do this is on the Office site at Running a macro when Excel starts You can then add the code that renames and creates the sheets with the right names ... full answer >
Tags:
- excel
1Answer

0Comments
Microsoft Excel's top 5 tricks

By macslocum : 20 August 2010 - 04:28 AM
Excel is the go-to choice for number crunching and spreadsheet creation, but those are the run-of-the-mill functions. There's a host of untapped tools and techniques within the program. In the followi...
Tags:
1Vote

1Comment
Handling Duplicate Rows in Excel 2010

By chco : 21 July 2010 - 11:19 AM
The following is an excerpt from Excel 2010: The Missing Manual. It explains what to do to address the issue of duplicate rows in Excel 2010.Hard-core table types know that every once in a while, desp...
Tags:
0Votes

0Comments
Using Information Functions in Excel 2010

By chco : 21 July 2010 - 06:52 AM
The following is an excerpt from Excel 2010: The Missing Manual. It explains the use of information functions and offers a few tips.Excel features yet another group of functions closely related to the...
Tags:
1Vote

0Comments
What happened to my Excel toolbox?

Asked by BJPatt : 21 July 2010 - 06:32 AM
Tags:
- excel
0Answers

0Comments
How can I embed multiple images in Excel using POI?

Asked by peeps : 15 July 2010 - 03:45 AM

Answered by alagu k : Nov 08 2010 03:08 AM
hi peeps, Am also facing the same problem which u ve faced. Only the second image is displayed. First image is not displayed. do you have any solution now? its very much required for me to continue w... full answer >
Tags:
- excel
- poi
1Answer

0Comments
How to Find the Last Day of Any Month in Excel

By sarahkim : 01 July 2010 - 03:58 PM
This excerpt from Excel 2010: The Missing Manual shows you how to use the EOMONTH() function to calculate the last day of any month. The EOMONTH() function (short for End of Month) calculates the last...
Tags:
0Votes

0Comments