Rabu, 23 Juni 2010

Microsoft Excel: Change Shape Of Comment To A Star

Problem: As shown in Fig. 1172, you have a comment in a cell. Jazz up your spreadsheet by changing the shape of the comment into a starburst or any other AutoShape.

See all Microsoft Excel tips

Strategy: You can change the shape of a comment. Follow these instructions.

1) From the cell, right-click and select Edit Comment. Diagonal lines appear, as shown in Fig. 1173.

2) Click on the diagonal lines to change the comment from edit text mode to edit mode, as shown in Fig. 1174.

3) If you do not have the Drawing toolbar displayed, choose View – Toolbars – Drawing from the menu.

4) On the left side of the Drawing toolbar is a dropdown called Draw. Choose this dropdown. From the menu, select Change AutoShape.

5) From the flyout menu, choose Stars and Banners. From the next flyout choose Explosion 2, as shown in Fig. 1175.

The comment will change from a rectangle to a starburst, as shown in Fig. 1176.

6) Grab a corner white Fill handle and drag to make the shape large enough for the text, as shown in Fig. 1177.

7) Right-click the dots border and select Format Comment. On the Alignment tab choose to center horizontally and vertically, as shown in Fig. 1178.

Result: The comment will appear as a starburst, as shown in Fig. 1179.

Additional Information: Grab the green rotate handle and rotate until you have the shape that best fits the text, as shown in Fig. 1180.

Summary: Using the Draw button on the Drawing toolbar, you can control the shape of a comment.

Commands Discussed: View – Toolbars; Draw – Change AutoShape

See all Microsoft Excel tips

Images

Fig. 1172Fig. 1173Fig. 1174Fig. 1175Fig. 1176Fig. 1177Fig. 1178Fig. 1179Fig. 1180






Share/Bookmark
Share to Facebook

Tidak ada komentar:

Posting Komentar

FOLLOWERS

LABELS

: wireless (1) 1005PE-H (1) 105mbps (1) 1080p (2) 2006 (2) 2007 (1) 256 (1) 2nd Language Acquisition (1) 3800-series (1) 3D (3) 4g (1) 720p (1) 8600 GTS geforce 8 series (1) 8800gt (2) about game (3) About GPS (7) Accessories (10) Acer (1) acquisition (1) active shutter glasses (1) ad (1) Adam (1) add-ins and patches (1) admob (1) advertising (3) Alarm clock (1) algiz (1) alienware (1) All Points Bulletin (1) altona (1) amazon (4) amd (4) amd still being stomped on by intel (2) analog hole (2) android (5) anti-malware (2) anti-spyware tools (1) anti-trust (1) anti-virus (2) antivirus (1) app (2) app store (1) apple (13) apple ipad (2) Applications of GPS (22) architecture flaw (2) ARM (2) Articles (152) Asetek (2) ask the doctor (1) asrock (1) asus (4) at-hdview (1) ati (5) atom (1) audio (1) Aurora ALX (1) automatic (2) backup (2) backup drives (3) ballmer (1) barnes and noble (1) Basics in Home Theater (41) battery (1) benchmarks (1) BenQ (1) BenQ FP202W (1) bestbuy (2) beta (1) Bing (1) biological implant (1) bios (1) bittorrent (5) blizzard (1) Blu-ray (3) Bluetooth (1) Bookmark (1) boot (1) bothced update (1) breakthroughs (1) broadband (1) broken (2) browser (3) buddy (1) bugs (1) build a pc (41) build-a-pc (8) buildapc (1) business (4) cable (2) cable card (1) Camcorder Reviews (29) Camcorder Tutorials (3) Camera Reviews (1) canon (1) card reader (1) case (3) cases (2) catalog (1) catalyst (1) cd-rom (1) cell phones (2) censorship (3) channel page (1) chassis (3) china (1) chip (2) chrome (1) chrome extension of the week (2) chumby (1) client (1) cloud computing (1) college (1) columns (1) Comcast (1) commercials (1) company news (1) competition (1) Complete PC Backup and Restore (1) computer (2) console (1) consumer (1) consumer electronics (7) content filtering (1) Cooler Master (1) copy protection (1) copyright (1) cordless (2) counter-strike (2) court (1) cpu (2) crash (1) creative (1) Crossfire (2) crowdsourcing (1) Crysis (1) Crysis 2 (1) Crytek (1) customize (1) Daily News Brief (5) data (1) data center (1) data privacy (1) data security (1) davidwater (1) Dead Space 2 (1) deadline (1) Defender (1) DELL (3) Dell 3007WFP (1) dell E228WFP (2) digital music (1) digital photography (2) Direct3D (1) DirectX (2) directx 10 (2) directx 11 (1) DirectX 9 (1) display (1) DisplayPort (3) displays (3) distributed computing (2) download (3) download of the week (1) downloads (1) driver (2) Drivers (2) dual-gpu (1) duplex (1) dvd (2) dvd compressing (1) dvd rip (1) DVD-to-MPEG4 (1) dx11 (1) e-book reader (1) e-reader (2) ebook (1) ebooks (1) Eco-2 (2) editor blogs (3) eee (1) eee PC (2) efficient processor use (1) eink (2) Eizo FlexScan S2410W (1) elecom (1) Electronic (3) Electronic Arts (1) email (2) empty promises (1) enclosure (3) encoding (2) encryption (1) energy costs (1) enterprise (3) Envision EN2028 (1) ereaders (1) errata (2) exanet (1) extreme (1) eyefinity (1) facebook (2) fair use (4) fast (1) fcc (2) feature (3) features (4) fedora (1) fermi (2) Fiber (1) fiber optics (1) file (2) files (1) firefox (1) firefox addon of the week (1) first build (1) flash (1) FM Radio (1) Free Online Music Services Listeners Guide (1) freedom (1) freeware (4) from the magazine (11) front-panel (1) froyo (1) ftc (1) FTP (2) fujitsu (2) g73 (1) Gadget (2) gadgets (1) game phone (1) games (8) gaming (6) gaming lcd (1) gaming mouse (1) Gateway FPD2185W (1) gear (1) Geocaching (12) Ghost Recon: Advanced Warfighter (1) Ghost Recon: Future Soldier (1) gimp (1) gmail (3) gmail drive (1) gnome (1) gobi (1) google (15) google buzz (1) google io (1) google maps (1) google moderator (1) google street view (1) Google TV (1) Gordon (2) GPS (1) GPS Products - Software (1) GPS Products - Software (13) GPS Products -Software (1) GPS Support (2) gpu (5) graphics (6) greatest (2) green energy (1) gtx 465 (1) gtx 490 (1) guide (1) gutsy (1) haf x (1) half assed attempt (2) handheld (1) hard case (1) Hard Drive (3) hardware (44) hd (2) hd 5570 (1) HDCP (2) HDD (2) HDMI (3) HDTV (2) head to head (1) headphones (2) heal (1) help (1) Herbal Sciences - Medicine (1) Hewlett Packard (1) hewlett-packard (1) high definition (1) High Defintion (1) Holiday (1) Home Entertainment Centers (18) Home Media (32) Home Office Setup (1) Home Sound (18) Home Vision (29) host (2) house cleaning (1) how_to (6) hp (2) HP L2045W (1) HP LP2065 (1) HP LP2465 (1) HTPC - Cablecard PC (15) HTPC -- Cablecard PC (1) HTPC -Cablecard PC (1) HTPC- Cablecard PC (1) HTPC-Cablecard PC (2) http://www.maximumpc.com/tags/notebooks (1) hv10 (1) Hybrid (1) iad (1) ibm (1) ibuypower (2) idc (1) india (1) indonesia (1) industry news (1) information appliance (1) innovation (2) inoculate (1) instance (1) intel (2) Internet (7) Internet access (1) Internet Explorer (2) Internet radio (1) IP address (1) iPad (3) iphone (2) IPOD (5) ips (1) iran (1) ISP (1) isuppli (5) IT (1) itanium 9300 (1) itunes (3) iwireless (1) jimmy wales (2) josh (1) june (2) Justin Long (1) kick ass (1) kick-ass (1) kickass (1) kina grannis (1) kindle (3) Klipsch ProMedia Ultra 2.0 (1) labs (1) laprop (1) LAPTOP (8) law (3) lawsuit (1) lcd (2) lcd2470wnx (1) legal (3) LENOVO (2) level 10 (2) library (1) linux (4) liquid cooling (2) list (2) load (2) lost (1) loyd case (1) lte (1) M-Audio Studiophile AV 40 (1) Mac (4) Mac Mini (1) mac os x 10.4 (1) macworld (1) Mafia Wars (2) malware (1) Manned Space Travel (1) Maps (4) marcus soperus (1) marvell (1) maximum pc challenge (1) medal of honor (1) media (5) Media - Conversion (3) Media -Conversion (1) Media Sharing - Streaming (16) Memory (2) merger (1) Methods - Ideologies (1) mice (1) microsoft (6) mobile (15) mobile advertising (1) mobile data (1) mobile phones (1) mod_shop (1) monitor (2) monopoly (1) motherboard (1) mouse n keyboard (2) movies (7) Mozilla (1) mp3 (3) MP3 Accessories (1) mpaa (2) mr-a001bk (1) multimedia (3) multitasking (1) multitouch (2) music (5) Music Industry (1) MXM (1) mybook pe 500gb (2) nand (1) nas (1) nas boxes (1) National Broadband (1) nec (2) NEC Multisync 20WMGX2 (1) nerfed snipers (1) netbook (3) netbook navigator (1) NetFlix (2) network security (1) NEWS (13) nexus one (1) nintendo ds (1) nook (1) notebook (7) Notebook Review (5) Notion Ink (1) november (1) November 2007 (1) npd (1) nvidia (6) NVIDIA TEGRA (1) objectionable content (1) OEM (1) office (2) olpc (1) olympics (1) online (1) Online Classes (1) online security (1) online video (2) open source (2) operating system (3) Optimus technology (1) oracle (1) organize your life (1) organizer (1) Orientation (1) OS (4) Other Collaborative Tools (1) overclocking (1) overheating (1) Pac-Man (1) panasonic (2) Pandora (1) pandora handheld (1) part two (1) Patch Tuesday (1) patent (1) pay-per-use (1) pc (1) pc build-off (1) pc market (1) PC TOOLS (1) Peripherals (2) Phenom (2) Philips 230WP7 (1) phones (1) photo (1) photography (1) piracy (3) pixel qi (1) plasma (1) play (1) play free game (1) player (1) Playstation 3 (1) plugin (1) plus (1) PM Certification (1) poll (1) popular (1) pornography (2) portable (1) power supply (2) Preparing for College (1) prices (2) Privacy (2) processor (4) PRODUCT REVIEW (1) productivity (2) Professional Development (2) Profits (2) Project Planning (1) proprietary (1) ps3 (1) PSU (2) px 210 bt (2) quad core (1) radiotracker (2) rapidshare (1) Raven 2 (1) recall (1) recover (1) red hat (1) regulation (1) regulations (1) remote (2) remote access (2) report (2) reregister (1) Resource Management (1) restore (1) revenue (2) reviews (23) rfid (1) ribbon hero (2) rigs (10) rim blackberry (1) roundup (2) rumor (1) safe shopping (1) Safety Mode (1) Samsung 214T (1) Samsung 970P (1) save (1) savvio (1) scanner (1) ScanSnap S1300 (1) Science (1) SDXC (1) seagate (2) search (3) Security (5) selective output control (2) semiconductor (2) Sennheiser (2) september 2007 (1) server (2) service (1) service pack 1 (1) session (1) showdown (1) sidewinder (1) silence (1) silent (1) Silverstone (1) Site (1) Six Sigma (1) sli (2) slipstream (1) Smartphone (1) smartphones (3) soc (2) Social Networking (4) social networks (1) SOFTWARE (33) Software Reviews - Tips (1) Software Tips - Reviews (1) solid state storage (1) sony (1) Sony PSP (1) soundcard (1) soundcards (1) SP1 (1) sp1 performance (1) sp1 release date (1) Space Technology (1) speed (1) spray (2) spyware (1) ssd (1) star wars (1) StarCraft II (1) Steam (2) storage (1) stream (1) streaming (2) Street View (2) study (1) support (1) suspension (1) symantec (1) Systems (1) t101MT (2) tab (1) Table PC (1) tablet (11) tablet pc (1) tag (1) Teach - Learn English (ESL) (1) Teaching Spanish (3) team fortress (2) tech (1) tech innovations (2) technology (1) television (1) Texas Instruments (1) TF2 (2) thermaltake (2) thinkstation E20 (1) tj07 (2) top 100 (2) torrent (3) toshiba (1) touchco (1) transfer (2) transferjet (1) troubleshooting (1) tunes (1) tv (3) TV recording (2) twitter (1) U.S. Air Force (1) ubisoft (1) ubuntu (2) ultra-thin (2) UltraSharp U2711 (1) unreal engine three (1) URI (1) usb (2) usb controller (2) user unfriendly (1) usps (1) utility (1) utorrent (3) verisign (1) Verizon (1) VIA (1) video (5) Video Conferencing Review (1) video games (2) video on demand (2) videocard (5) videocards (1) Videogames (2) videos (1) vidoegames (1) Viewsonic VX2035WM (2) viruses (1) vista (2) vod (2) Walmart (1) Warner Bros (2) Watchdog (1) watercooling (2) web (1) web exclusive (2) wepad (2) when will amd strike back (2) white paper (1) wi-fi (3) wikimedia (2) wikipedia (2) WiLink 7.0 (1) will in a penguin suit (1) will smith (1) wimax (1) windows (3) windows 7 (1) windows bugs (1) windows live mail (1) Windows Media (1) Windows Media Player (1) Windows PC Optimization Guide (1) Windows Vista (4) windows xp (1) winxp (1) wireless (2) wireless data (1) wireless pen tablet (1) workstation (1) x-fi (1) Xbox 360 (1) Xerox XG-91D (2) youtube (2) z800 3dvisor (1)