Excel: Can I make something similar to an autoflow text box? - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 10-14-2006, 04:39 AM   #1 (permalink)
purveyor of fine cheeses
 
Join Date: Apr 2004
Posts: 323
Question Excel: Can I make something similar to an autoflow text box?

Hi,

I'm trying to make a attendance sheet for my church. Basically, it has the names of all the members of the congregation on it, and the usher marks who attends the service.

People are constantly joining our congregation and it is annoying have to alter the attendance sheet each time someone joins the church.

Currently the page is A4, and split in half vertically so the names go down one side, then start again at the top of the next half. What I am wondering is whether it is possible (as I am quite hopeless with Excel formula) to make the text automatically flow from the bottom of the first half to the top of the second half. This would be great so that when I enter a new name they all move down, and flow onto the next half. Is this possible, or am I better using something like Publisher? I currently use Publisher, but it's a bit tacky, and I'd rather use Excel for the ease of creating borders and boxes.
__________________

__________________
<img src=\"http://img.photobucket.com/albums/v208/knowledgelifeguard/homer21.gif\" alt=\"Image hosted by Photobucket.com\" width=\"125\" height=\"104.8\"> <font size=\"1\"><i>\"I like these real Saturdays, not like that fake one that almost got me fired.\"</font></i>
SupremeRuler99 is offline  
Old 10-14-2006, 05:51 AM   #2 (permalink)
Monster Techie
 
MrCoffee's Avatar
 
Join Date: Feb 2006
Location: UK
Posts: 1,858
Default

I'm quite experianced with excel and i've never seen anything like that done but then my experiance in mostly data manipulation and analysis so presentation isn't something i'm familiar with.
I don't think you can do it easily but i could be wrong.

Why not just use word with the page split into columns?
__________________

__________________
Intel core I7 920
GA-EX58-UD3R
6GB OCZ platinum 1600
XFX HD4890
Noctua nh-u12p
Corsair HX520
Antec 300
Samsung 1TB F1 Spinpoint
Samsung SM2443BW 24"
MrCoffee is offline  
Old 10-14-2006, 06:16 AM   #3 (permalink)
purveyor of fine cheeses
 
Join Date: Apr 2004
Posts: 323
Default

Hmmm... yes, I suppose that would be a better way of doing things. Thanks for your help!
__________________
<img src=\"http://img.photobucket.com/albums/v208/knowledgelifeguard/homer21.gif\" alt=\"Image hosted by Photobucket.com\" width=\"125\" height=\"104.8\"> <font size=\"1\"><i>\"I like these real Saturdays, not like that fake one that almost got me fired.\"</font></i>
SupremeRuler99 is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 07:52 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.